conditional formatting?

[Joann]

I have two columns....some of the cells in Column A differ from the cells in
column B...how do I hilight the cells in column A that are different from the
ones in column B? thanks!

Jo

 

[David Biddulph]

Either CF/ Cell Value Is/ not equal to/ =B1
Or CF/ Formula Is/ =A1<>B1