cell to change colour at given date - how to

T

Tobit

I have a cell in a spreadsheet into which I type a date. When the pc clock
shows that the date in the cell is more that 30 days old I want the cell to
turn red. How would I do that.

Basic to many of you I am sure, but to someone who doesn't use this side of
Excel, virtually impossible ! (I'm using Excel 97 if that makes any
difference - but I presume not)

Thanks in advance

Tobit
 
T

Tobit

Ken- thanks for solving my original problem. One follow up question.

If I put a standard formula in A1 say =A2+B2, I can drag that to the cells
below and it will change for each cell =A3+B3 etc

If I set up A1 with a conditional format say =(TODAY()-$A$1)>30, is there
any short cut that I can use to drag the format to other cells with the same
automatic changes eg =(TODAY()-$A$2)>30, =(TODAY()-$A$3)>30 etc

Tobit Curteis
___________

Cambridge
UK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
How to change date format to 7 working days a week in ms project 2010? 0
Update specific cell at a specific time 6
Using colour conditional formatting to show whether due date has past 0
Using CF to change colour in cell based on date? 4
How can i put text in a cell depending on colour 0
change colour of cell in word table following numerical input 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top