You may use Conditional Formatting for your desired results. In Office 2007
go to HOME and then STYLE and then CONDITIONAL FORMATTING. System will guide
you how to fetch results...

"Tracey G" wrote:

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