Hi everyone, I'm trying to use conditional formatting to highlight (green) a row if a particular cell in that row:
- contains any text at all
Also, I'd like the row to highlight a different color (red) if a particular cell in that row:
OR
- is empty
- contains the word "batch"
Any idea how to do this? I've attached an example.
Thank you!
Bookmarks