logic for Comparing columns in excel

[sathyaanil37]

Hi,

I have data in two cells.If both are different then it should display that column data with different color.

EX:

COL A COLB
1 1
2 1

If col b is not match with col A then it should display that col B value cell with some color.Any one can help me on this.

[Richard Buttrey]

Hi,

Use Conditional Formatting with the 'Use a Formula' option and put a formula in the column B cells Cond. Format box and set the colour accordingly.
e.g. =B1<>A1