Highlight a cell with a specific word in it
Hi,
I'm trying to highlight a cell using CONDITIONAL FORMATTING if the cell has
the word "Repair" in it anywhere. Example: "123456 - REPAIR" will be in the
cell and the conditional format will recognize the word "Repair" and
Highlight the cell.
Is it possible to do that?
Thanks.
|