Cells changes colour if....

D

Derek

Hi all

I wonder if you can help with this one

I would like cell G6 to change to green if cells B6, E6 and F6 have a Y in
them, is this possible? im using office 2007

Many thanks

Derek
 
D

David Biddulph

Format/ Conditional Formatting/ Formula Is/ =AND(B6="Y",E6="Y",F6="Y")
Choose your green colour in the format.
 
Top