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!
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:
- Conditional Format
- Kingston format utility - Download - Storage
- Format factory - Download - Other
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
- Excel date format dd.mm.yyyy - Guide
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
555
Jun 6, 2017 at 11:52 AM
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
The formula to use is:
=AND(A2="YourSpecificWord",$AI$2<1)
The applied to range will then be A2:U161.
Best regards,
Trowa
