ConditionalFormat where values in two fields match (1 Viewer)

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 02:18
Joined
Jan 20, 2009
Messages
12,849
Conditional Formatting a table. I want values in a field to be highlighted where they are equal to a value in the same record of another field.

I know I have done something similar before and it automatically propagated to the whole field. I am pretty sure the expression changed to a field reference.

I don't get how Microsoft could have made Conditional Formatting of a table so obtuse when similar functionality works so simply in Access.
 

isladogs

MVP / VIP
Local time
Today, 15:18
Joined
Jan 14, 2017
Messages
18,186
I haven't needed to do this for years in Excel and, looking at it again today, it's changed beyond all recognition since that time.

The convoluted approach I used in the past was to add an additional column which compared the two values and had value 'T' if they are the same, otherwise 'F' or null.
Then I used conditional formatting to take effect if the comparator value ='T' .

I hope there's a better way than that but it does work.
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:18
Joined
Sep 21, 2011
Messages
14,044
Here is an example, but as you say, it is not particularly intuitive.
It took me several attempts to get this working as I have not done one for quite a while. :D

HTH
 

Attachments

  • CF example.xlsx
    9.5 KB · Views: 136

Users who are viewing this thread

Top Bottom