Forum Discussion
Highlight a cell if a different cell isn't blank
Short Explanation I'm trying to highlight a cell based on 2 conditions: 1. The cell contains an exact word ("Scheduled") AND 2. A different cell in the same ro...
I recommend this formula in the Status column:
=IFS(E3,"Complete",NOW()>B3+D3,"No Show",TRUE,"Scheduled")
as for conditional formatting you use custom formula and a formula like this:
applied to range C:C
=(C1="Scheduled")*(E1>0)
=IFS(E3,"Complete",NOW()>B3+D3,"No Show",TRUE,"Scheduled")
as for conditional formatting you use custom formula and a formula like this:
applied to range C:C
=(C1="Scheduled")*(E1>0)