Forum Discussion

Copper Contributor

Mar 03, 2026

Conditional Formatting a specific word

First post here, so hoping someone can help me. I work for a repair facility. I track our repairs in excel. I have an “order” tab that tracks all the important information for the repairs. I also hav...

excel

IlirU

Iron Contributor

Mar 04, 2026

JNH415531,

Select cells you want in column A and in Conditional Formatting apply below formula:

=--SUBSTITUTE(LOWER($B2:$B10), TEXTAFTER($A2:$A10, ": "), "") > 0

Format cells with color you want.

Change the range in formula as per you need.

Hope this helps.

IlirU