Thread: Date sensitive colour coding?

Hello,

I am trying to put together a register of details for a company that includes information that must be updated yearly. I am a relatve noice to excel, with only minor experience using IF statements and conditional formating.

In short I need a function that will look at a date, and if it is more or less then a year old (always using todays date), give a numerical value (e.g. 1 for less, 2 for more) and allow me to use conditional formatting.

Thanks
adbh

Edit: I am using Office 2007

Use this formula -

=IF(TODAY()-A2>365,2,1)

Then you can proceed with putting conditional formatting for the 1s and 2s.