Need guidance for conditional formatting in excel 2007

[ThrottleWorks]

Hi I need help for conditional formatting.


Following example will be easier for us to understand the problem.


I have two columns A & B, I want to do formatting in column B.

Both the columns has numbers values.

Criteria is


if Cell A2 = 0 and cell B2 <> 0 then cell B2 should be marked red else as it.


I tried various combinations unsuccessfully, can someone help me in this please.

 

[Luke M]

=AND(A2=0,B2<>0)

Format red


If there's some concern about blanks in A2, could expand it to:

=AND(A2=0,ISNUMBER(A2),B2<>0)

 

[ThrottleWorks]

Hi Luke Sir, it has worked, thanks a lot for the support. Have a nice day.

 

[Luke M]

You're welcome, and you too.