Conditional Formatting

[jason.hampton]

Group,

I have looked in the archives and not found a formula to assist me (my apologizes).

What I am attempting to do it created two rules for cells I9:I23.

Rule 1: (for Cell I9) contents of H9 is "NO" to have the red fill, yellow bold font.
Rule 2: (for cell I9) contents of H9 is "OK" to have green fill, bold black font.

Any help will be appreciated!

[Richard Buttrey]

Hi,

1. =$h9="no"
2. =$h9="Ok"

both with your chosen formatting and applied to I9:I23

[jason.hampton]

Richard,

Thank you for the rapid accurate reply! I was WAY over thinking it....

[Richard Buttrey]

My pleasure and thanks for the rep.