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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF or( If And ) can't get it to work 2
Copy Formula 3
using indirect to sum range 4
addind date stamp 0
IF and SUMIF 9
Formula using SUMIF & IF 3
Countif cell if other cells match criteria 3
sum of blank cells returns zeros 7

Top