CF and Dates Formula Needed

  • Thread starter Thread starter carol.taylor
  • Start date Start date
C

carol.taylor

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
 
Back
Top