Excel help wanted

[theothershane]

Hello, Everyone...

Does anyone know if there is a way of getting Excel to change the colour of a cell background containing a date, as that date approaches today's date? I have a list with lots of dates in it and at the moment have to look at the whole thing to find appointments coming up etc. It would be really good if Excel could just show me when a date is (say) 30 days away, today, already gone etc. maybe by colouring them red, amber or green...

I know nothing about Excel...

thanks

[oracle128]

You need Conditional Formatting. Select the cell that contains the date you want to check, then go to Format->Conditional Formatting.
Change the drop down box from "Cell Value Is" to "Formula Is".
In the formula text field, type: =AND($A$1-TODAY()<0,TODAY()-$A$1<=30)
where the cell you're in is cell A1, and you want to format the cell when the difference between the date in the cell and today's date is less than or equal to 30 (ie. the date in the cell is 30 days or less away from today).
Click the Format button, and format it how you want the cell to appear when that condition is true (eg. green background).
For every other possible condition you want to test for, click Add and repeat the steps.
You can test for 'today' by using this formula: =$A$1=TODAY() (amber)
You can test for a date that's passed with this formula: =$A$1-TODAY()>0 (red)

[theothershane]

Exactly right. Thank you very much!