Conditional Format depending on two cells

[hkbhansali]

Hi,


I am currently trying to write a formula for a conditional format depending on two cell using EXCEL 2007.

i.e i want to say if cell "Q5" contains anything (is not blank) and "R5" is =0 THEN turn "R5" Red.

Any help would be greatly appreciated!

Thanks

 

[Peter_SSs]

Try this.
Select R5 and in Conditional Formatting, Use a rule...
Formula: =AND(Q5<>"",R5<>"",R5=0)

 

[hkbhansali]

Thanks Peter_SSs,

It's work Perfect...what I want..

 

[Peter_SSs]

Thanks Peter_SSs,

It's work Perfect...what I want..

You are welcome. Thanks for letting us know.