Hi there,
I'm including conditional formatting to highlight a cell (where a date should be entered) if the cell next to it contains certain words. In this particular case, I would like the date cell to highlight if the cell next to it contains the word URGENT. My current formula is:
IF(A1="", B1="URGENT")
But it does not work, I'm guessing because B1 actually says "URGENT: ISSUE SOA" instead of just "URGENT". I would change the CF formula, but I want this same rule to apply to dozens of cells, so short of re-typing every single rule for every single cell, I would like a way for my formula to look for if B1 CONTAINS URGENT rather than looking to see if B1 is exactly equal to URGENT.
Hope this makes sense!
Bookmarks