Report

Conditional Format [Solved]

Ask a question Azion - Last answered on Jun 6, 2017 at 11:56 AM by Azion
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!

Helpful
+0
plus moins
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
Leave a comment
Helpful
+0
plus moins
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
Azion- Jun 6, 2017 at 11:56 AM
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.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!