Cells changes colour if....

  • Thread starter Thread starter Derek
  • Start date Start date
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
 
Format/ Conditional Formatting/ Formula Is/ =AND(B6="Y",E6="Y",F6="Y")
Choose your green colour in the format.
 
Back
Top