Compare fields and highlight the entries with Format Cells.

  • Thread starter Thread starter Mohan
  • Start date Start date
M

Mohan

Seems like an easy task but don't know how. Can somebody help?

I have to compare the entries of column A,B,C against that of column E,F,G.
I did the EXACT function as follows:
=EXACT(A1,E1) and so on.

and filtered for FALSE. But I also want to automatically Fill Color for the
cells where the entries don't match?? Is there ONE formula to do so?

Thanx,
Madan
 
Select A1:C9999 (with A1 your activecell)

Format|conditional formatting
=exact(a1,e1)=false
or
=not(exact(a1,e1))

then do the same thing with E1:G9999
 
Thanks! That works great.


Dave Peterson said:
Select A1:C9999 (with A1 your activecell)

Format|conditional formatting
=exact(a1,e1)=false
or
=not(exact(a1,e1))

then do the same thing with E1:G9999
Click to expand...
 
Back
Top