Book3.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | L | M | N | |||||||||||||
4 | 12/28/2019 | FALSE | FALSE | |||||||||||||
5 | a | 12/28/2019 | TRUE | TRUE | ||||||||||||
6 | 3/15/2021 | FALSE | FALSE | |||||||||||||
7 | b | 3/15/2021 | FALSE | FALSE | ||||||||||||
Sheet747 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
M4:M7 | M4 | =AND(A4<>"",L4<=TODAY()-365) |
N4:N7 | N4 | =AND(A4<>"",L4<=EDATE(TODAY(),-12)) |
exclude if column A isNOT blank then do the formatting
Book3.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | L | M | N | |||||||||||||
4 | 12/28/2019 | TRUE | TRUE | |||||||||||||
5 | a | 12/28/2019 | FALSE | FALSE | ||||||||||||
6 | 3/15/2021 | FALSE | FALSE | |||||||||||||
7 | b | 3/15/2021 | FALSE | FALSE | ||||||||||||
Sheet747 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
M4:M7 | M4 | =AND(A4="",L4<=TODAY()-365) |
N4:N7 | N4 | =AND(A4="",L4<=EDATE(TODAY(),-12)) |