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

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

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