Forum Discussion
Conditional Formatting a specific word
Yes you can. I think I created what you want but it is hard to know exactly how you have things set up without the sheet. Here is the formula I created:
=SUM(IF(ISNUMBER(SEARCH(TEXTAFTER(A1,": "),$B$1:.$B$9999)),--TRIM(TEXTAFTER(LOWER($B$1:.$B$9999),LOWER(TEXTAFTER(A1,": ")),,,,0)),0))based on the sheet looking like this:
and that formula is put into the conditional formatting under a custom rule applied to column A1 (either A:A or A1:Axxx where xxx is the whole range of A that you want it applied to)
That rule will look at each cell in A and check for the value after the ": " to be found in column B and if found then find the VALUE after that keyword and if it finds any value > 0 then it will highlight that cell according to the conditional formatting (in this case green).
In another post I will try to attach the sample file because this forum sometimes deletes posts with attachments....
- m_tarlerMar 03, 2026Silver Contributor
and here I will try to attach the sample file