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

"Derek" wrote in message
...
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