Conditional Format
Solved/Closed
Related:
- Conditional Format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- How to format hp laptop - Guide
- How to change whatsapp time format - 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
552
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
