Hi All,

I'm in need of some help, u have a column of dates which is called
"Target Date" in here are dates when actions are due by. I want to CF
the due date by a RAG style.

for Example if a traget date is 30/07/07 i want the cell next to it to
display gren

if target date is 01/06/07 i need it to display red

if target date is 2 days before it's overdue then i want it to display
amber.

I've tried various formulas on this group but i don't seem to be able
to get it to work.
I was initially trying to use "cell value is" greater then etc then
selecting the cell but that dosen't work. Do i have to include todays
date for it to be able to work out if the target date has passed or
not?

Thanks

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I'm in need of some help, u have a column of dates which is called
> "Target Date" in here are dates when actions are due by. I want to CF
> the due date by a RAG style.
>
> for Example if a traget date is 30/07/07 i want the cell next to it to
> display gren
>
> if target date is 01/06/07 i need it to display red
>
> if target date is 2 days before it's overdue then i want it to display
> amber.
>
> I've tried various formulas on this group but i don't seem to be able
> to get it to work.
> I was initially trying to use "cell value is" greater then etc then
> selecting the cell but that dosen't work. Do i have to include todays
> date for it to be able to work out if the target date has passed or
> not?
>
> Thanks
>