Conditional Formatting

[craig25]

If in cell c17 I type or paste the word "critical". It highlights that cell red. It also highlights d17:u17 red as well using (Use a formula to determine which cells to format).
The formula is =c17="critical". This works fine unless I type in "This is critical" in cell c17. All the other cells (d17:u17) the red highlight disappears. How can I fix that?

 

[Joe4]

Use this formula instead:

=ISNUMBER(FIND("critical",C17))

 

[craig25]

Thanks!! Works GREAT!!

 

[Joe4]

You are welcome!