highlight column A if column A does not equal to B

[liu]

How can I do that?

Thanks

 

[liu]

Also can I highlight a cell if it's of a certain value, eg. 0?

 

[Gord Dibben]

Select a range in column A and Format>Conditional Formatting>Formula is:
=$B1<>$A1

Format to a color and OK.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Format>Conditional Formatting>Cell Value is: equal to 0

Format to a color and OK


Gord Dibben MS Excel MVP