View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tracey G Tracey G is offline
external usenet poster
 
Posts: 1
Default Conditional formatting based upon due dates

Hi,

I have a spreadsheet which maps out events which will occur by date.
I simply wish to add a RAG status indicating:-

Dates that are due within three days as AMBER
Dates that are overdue as RED
All other dates in the future as GREEN

I have no clue as to how to do this, please help.
Thanks,
Tracey