Conditional Format

Solved/Closed
Azion - Updated on Jun 6, 2017 at 03:39 PM
 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!

Related:

2 responses

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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Jun 6, 2017 at 11:52 AM
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
0
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.
0