Conditional Format [Solved/Closed]

Azion - Jun 6, 2017 at 10:52 AM - Latest reply:  Azion
- Jun 6, 2017 at 11:56 AM
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 

3 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
TrowaD 2369 Posts Sunday September 12, 2010Registration dateModeratorStatus June 21, 2018 Last seen - Jun 6, 2017 at 11:52 AM
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.