Hi,

I have a spreadsheet that contains a column of dates. I would like these dates to change color if they are greater than or equal to 1 month old.

Does anyone know the formula to do this? Or can point me to any help sites?

Thanks

Set up a cell next to the date cell. Somewhere on the sheet set up a cell with today's date. Then enter an if formula causing something like past due to pop up in the new cell you created. You could even have it show you how many days past due or string several together to give different words for different periods.

Example: =if(dateduecell<todaydate-30,"PD"," ")
I just tested this one
=IF(E9<E7-30,"PD"," ")

Thanks for the reply but I just need it to change color and it needs to be exactly one calendar month rather than 30 days.

I found this site (http://www.excelforum.com) and have asked there :)

Im doing excel in college at the moment.

You could try asking at http://www.experts-exchange.com :) Pretty nice people there.