Conditional Formating based on 3 Conditions

[Moggy]

I'm sure its been covered before, but have been searching to no avail.
I have a list of clients/jobs. each row contains a column of data of date,
job address, invoice date, cost. I also have 3 columns that have a drop down
choice of yes or no. What i would like is if each of these selections is 'No'
then row text is fromated to Red, if columns 1 & 2 = 'No' & col 3 = 'Yes' the
row text is Blue, and if all three cols = 'Yes' then all text in that row
becomes Green.

The main purpose of this is just to give a visual representation on the
spreadsheet at a quick glance.

Thanks in advance for the help i'm sure i will get.
Have a good day/night

Moggy

 

[Andrea Jones]

Assuming your three drop-down boxes were in columns D, E and F you could set
up the 3 conditions as follows (just substitue D, E and F for your three
columns):

Condition 1
Formula Is =AND(IF($D2="No",1,0),IF($E2="No",1,0),IF($F2="No",1,0))
Set format to Red text

Condition 2
Formula Is =AND(IF($D2="No",1,0),IF($E2="No",1,0),IF($F2="Yes",1,0))
Set format to Blue text

Condition 3
Formula Is =AND(IF($D2="Yes",1,0),IF($E2="Yes",1,0),IF($F2="Yes",1,0))
Set format to Green text

You should be able to use the format painter to copy this conditional
formatting to all required cells. Of course combinations like Yes, No, Yes
will stay black.

Andrea Jones
www.stratatraining.co.uk

 

[Moggy]

Thanks Andrea,
Worked Great.
Have a good day