I'd like to highlight a cell in Column A IF the corresponding cell in Column G is blank AND corresponding cell in Column C contains "this" OR "that". Partial text should be applied to Column C as other words are in the cell.
I have tried this formula: =AND($G1="",$C1="this",$C1="that") but it doesn't work. I think my problem is Excel is looking for specific text "this" and returns false if other words are in the cell. I thought maybe an asterisk would help but it doesn't. Thoughts? Thanks!CONDITIONAL FORMAT.png
Bookmarks