ConditionalFormat where values in two fields match

[Galaxiom]

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]

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]

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.

HTH