Hello,
I'm looking to conditionally format a date cell to be highlighted based on two conditions.
The first being date in the cell exceeds a week highlight the cell, but only if another cell value doesn't equal 0,1. An example below, Column M has the dates that are to be conditionally formatted if they are past a week, but not if column T has a value of 0 or 1.
Column M Column T
I'm looking to conditionally format a date cell to be highlighted based on two conditions.
The first being date in the cell exceeds a week highlight the cell, but only if another cell value doesn't equal 0,1. An example below, Column M has the dates that are to be conditionally formatted if they are past a week, but not if column T has a value of 0 or 1.
Column M Column T
Anticipated Notification Date | Won (1) Loss (0) |
6/30/2020 | 0 |
6/30/2020 | 0 |
6/30/2020 | 0 |