Conditional formatting Excel 2000 1

[tgmoon]

I am trying to get a cell to change color if certain conditions are met in the three cells before it.

So, if cells $I12, $I13, $I14 all say "Yes" then cell $I15 will turn Green, But to complicate things, if any of the first 3 cells says "NR" and the rest still say "Yes" then $I15 will still turn green!!

Is this possible?

Many thanks in advance.

 

[GlennUK]

Use this formula in the conditional formatting for I15 ...

=AND(OR($I$12="Yes",$I$12="NR"),OR($I$13="Yes",$I$13="NR"),OR($I$14="Yes",$I$14="NR"))

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[tgmoon]

Thanks for that Glen.

Works a treat.

A star for you.