Conditional Formating

[hollarindy]

I need a little help with some conditional formating. This may be a case of i've been staring at this database too long. As you can see in the attached files I have 2 reports. They both have conditional formating to show me duplicates on each report (they show in red). There is additional formating to highlight items in yellow for example in the rptRandom report you can see that 33K6-4-3176-1 shows in red if that entry also appeared on rptOvrDrw it would be highlighted in yellow on rptOvrDrw.

What I need help with is highlighting items that appear on both reports but are not duplicates. For example on rptRandom 3rd row from the top 33K6-4-677-1 also appears on the rptOvrDrw. I need to figure out how to highlight these entries that appear on both reports but only one instance per report.

I hope I explained that well enough. If not let me know and as always your guidance is appriciated.

 

[llkhoutx]

Use a control conditional format criteria expessrion to compare the first report's control value to the second report's control value.

 

[hollarindy]

Do you have an example?

 

[llkhoutx]

Forms!FormA!ControlA=Forms!FormB!ControlB

Note that you can't use "Me."