Conditional Format

Azion - Updated on Jun 6, 2017 at 03:39 PM
 Azion - Jun 6, 2017 at 11:56 AM

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.



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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 6, 2017 at 11:52 AM
Hi Azion,

The formula to use is:
The applied to range will then be A2:U161.

Best regards,
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.