Conditional formatting one cell based on a condition in a range.

[bigsi1984]

Hello,

I have a cell S9 that I want to turn red if an of the cells below it contain the word invalid.

All of the ells below it use conditional formatting how either ok or invalid. The issue is there are 200 cells and unless any of the first 10 or so are invalid you have to scroll. I am looking for a solution that immediately highlights if there are any invalid entries.

Can you help?

 

[Legacy 436357]

You're welcome!