Forum Discussion
Solved
conditional formatting if other cell contain value
Hello! In the column B:B I can have 2 different worlds. I'd like to format the correspondent cell in the column A:A based on the value of B:B. For example: HELLO approved HI approved ...
IMHO, it's easier to apply to column A green rule
=$B1="approved"
and red rule
=$B1="denied"
Please see second sheet in attached
IMHO, it's easier to apply to column A green rule
=$B1="approved"
and red rule
=$B1="denied"
Please see second sheet in attached
Thank you very much!
- I preferred that solution because if you ever want to export that file to an online excel (such as calcs on googledrive) you may find some issues with that conditions.
I see no problems with Excel Online
