Hi
to start with you should replace E2 in your CF with $E2
Your formula for green should be =($E2-today())>90
The others can just boil down to
=($E2-today())>=61
=($E2-today())>=31
=($E2-today())>=0
As for including the condition in col G you did not specify what it MIGHT contain except a date
Supposing the cells in G contain a date or are empty, try adding a condition to all of your previously defined CF's, like
=AND($G2="",($E2-today())>90)
etc..
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|