Conditional Format [Solved/Closed]

-
Hello,

I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has <1, and I want it to search the sheet for a specific text if it is <1 then to highlight those cells that contain the specific text.

Thanks!

See more 

2 replies

0
Thank you
To add to that -- I could always have it generate the word itself that I want to be highlighted, but even then the MATCH formulas I have used seem to not work. I want it to search the entire sheet for this specific word using range A20:U161
Posts
2570
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2019
377
0
Thank you
Hi Azion,

The formula to use is:
=AND(A2="YourSpecificWord",$AI$2<1)
The applied to range will then be A2:U161.

Best regards,
Trowa
Thanks!!! I had not even thought about approaching it this way. I was making it way more complicated than needed! You rock!

Have a wonderful day.