Conditional Format Several Cells Based on Content of Another Cell

[JScotty317]

I've searched the stickies and FAQs and haven't found anything -- after 20+ hours of dedicated research I HAVE to ask you folks how to do this...

Initially, I was searching for a formula to set the format of Cell H3 if Cell C3 contains "0 - Completed" as a text string. Then if C4 contained "0 - Completed", set the formatting of H4 and so on. I got this to work:

• =ISNUMBER(SEARCH("0 - Completed", C1))=TRUE
• Applies to Column H only

However, now I would like this rule to apply to an entire row -- Column A through Column O -- instead of just Column H. I used the same formula and applied it to the whole worksheet (=$1:$1048576) and this formula clearly doesn't work for this.

Does anyone have any input on how to set this up? I'm at my wits end.

Thanks!

- Justin

 

[MarcelBeug]

Try blocking column C in your formula: =ISNUMBER(SEARCH("0 - Completed", $C1))=TRUE

 

[JScotty317]

Try blocking column C in your formula: =ISNUMBER(SEARCH("0 - Completed", $C1))=TRUE

You are the best -- thank you for the speedy response! Such a simple fix, clearly my brain is shot to have missed that one. This is why forums are the way to go.

Cheers!
- Justin

 

[MarcelBeug]

You're welcome.