Conditional formatting

[thedeadzeds]

hi guys

I have this formula =AND($C3>0,LEN($F3)=0). This changes F3 to a colour if C3 has data in it. I bascially want to amend it to do the following:

If cell d4 is = to "full fail" or "sense fail"

then

cells e4, f4 and g4 all turn blue

and

If cell e4 is = to "full fail" or "sense fail"

then

cells f4, g4 and h4 all turn blue

and

If cell f4 is = to "full fail" or "sense fail"

then

cells g4, h4 and i4 all turn blue

and so on

[NBVC]

Select each group of cells to colour one at a time,
so select e4,f4,g4 and add conditional format

OR(D4="full fail",D4="sense fail") and select colour,

click Ok, click Ok to exit, and then select next group and repeat with OR(E4=.....)

etc..

[thedeadzeds]

thanks, is there anyway of applying this to the whole sheet without doing it individually?

[NBVC]

you can copy and paste special >> Formats to the other cells.

or you can preselect all cells in the row for each group one at and apply conditional format as if you were applying to top most row in your selection....