View Single Post
 
Old 07-05-2023, 11:45 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 10 Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote