Conditional formatting

  • Thread starter Thread starter Ramon Mendoza
  • Start date Start date
R

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.
 
I forgot to ask if it also possible to drag that conditional formatting along
with the formula to the rows below.
 
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
 
Back
Top