Compare fields and highlight the entries with Format Cells.

[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

 

[Dave Peterson]

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

 

[Mohan]

Thanks! That works great.

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