Colour change by date
 

I have searched for an answer to this but haven't managed to nail it:
I wish to colour cells containing future dates within 30 days of TODAY() red.
This bit is straightforward, but I wish to ignore all dates which have
passed (ie yesterday and beyond)
How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be
better?
Ideally, I'd like something like
Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green.

Thanks in advance
--
Traa Dy Liooar

Jock

Colour change by date
 

You need to add an and

=and(D7-TODAY()<30, D7-TODAY() 0)

"Jock" wrote:

I have searched for an answer to this but haven't managed to nail it:
I wish to colour cells containing future dates within 30 days of TODAY() red.
This bit is straightforward, but I wish to ignore all dates which have
passed (ie yesterday and beyond)
How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be
better?
Ideally, I'd like something like
Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green.

Thanks in advance
--
Traa Dy Liooar

Jock

Colour change by date
 

Nice and simple
Thanks Joel
--
Traa Dy Liooar

Jock


"Joel" wrote:

You need to add an and

=and(D7-TODAY()<30, D7-TODAY() 0)

"Jock" wrote:

I have searched for an answer to this but haven't managed to nail it:
I wish to colour cells containing future dates within 30 days of TODAY() red.
This bit is straightforward, but I wish to ignore all dates which have
passed (ie yesterday and beyond)
How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be
better?
Ideally, I'd like something like
Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green.

Thanks in advance
--
Traa Dy Liooar

Jock