highlight column A if column A does not equal to B
 

How can I do that?

Thanks

highlight column A if column A does not equal to B
 

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

highlight column A if column A does not equal to B
 

Select a range in column A and FormatConditional FormattingFormula is:
=$B1<$A1

Format to a color and OK.


Gord Dibben MS Excel MVP

On Thu, 1 May 2008 15:57:31 -0700 (PDT), liu wrote:

How can I do that?

Thanks

highlight column A if column A does not equal to B
 

FormatConditional FormattingCell Value is: equal to 0

Format to a color and OK


Gord Dibben MS Excel MVP

On Thu, 1 May 2008 15:58:29 -0700 (PDT), liu wrote:

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