How to highlight cells that do not contain a certain words? Like highlight if the cell does not contain either “USD”, “GBP” or “EUR”. Thank you!
How to highlight cells that do not contain a certain words? Like highlight if the cell does not contain either “USD”, “GBP” or “EUR”. Thank you!
One way is to use Conditional Formatting. Set up exclusion words in a table and use the ISERROR and VLOOKUP functions.
See attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks