Conditional formatting

[Ramon Mendoza]

How can I apply a conditional format to a cell whenever 2 conditions are met?

Let's say, for example, I want cell A1 to be colored red if cells A3="Yes"
and A6<>0. But only if both are met, otherwise color it green.

Thank you.

 

[Ramon Mendoza]

I forgot to ask if it also possible to drag that conditional formatting along
with the formula to the rows below.

 

[John]

Hi Ramon
If you would like the CF on more then 1 cell, just select the range then
goto Conditional Formatting, choose Formula is: and type this in
=AND(A3="Yes",A6<>0)>goto Format >Choose colour. Thay it...
HTH
John