Conditional Format
Solved/Closed
Related:
- Conditional Format
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- Hp usb disk storage format tool - Download - Storage
- How to change date format in excel - 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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
6 Jun 2017 à 11:52
6 Jun 2017 à 11:52
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
