Cell referenced to current date

[stryker]

Hi

Can someone please help me?

I need to reference a cell that has a date in it, with the current date. For example, cell A1 has the date 1/1/05 and todays date is the 11/1/05.

What I would like is for the cell A1 to automatically change to a different colour when the date gets to a certain age. For example, cell A1 is now 10 days old and would need to have a red background.

Can any one point me int he right direction?

Thank you

Nathan
Stryker Medical

[eluehmann]

How about:
Click A1
Format -> conditional formatting

Formula is: =(A1+10)<NOW()

set your backround color to red

[stryker]

Oh thanks, but what about if I wanted it to display different colours for different time periods.

eg: <10 days red
<20 days blue

etc etc

Thank you

[stryker]

Just to clarify; the daily date needs to update each day, which means the cell values will increase and should change colour appropriately.

eg: 10 days old red
20 days old blue

I think the formulae needs to say something like =IF >10 or If >20 etc

Anyone know?

thank you

[stryker]

Ok, here is my final request.

I have 3 columns.

Column A has variable data in a drop down box. The choices are: completed
in progress
per.

In column 2 I have a start date

In column 3 I have todays date minus the start date displayed as a number.

I need to first reference column A, if column A says "completed" the cell should be yellow. If Column A says completed and column 3 is greater than 10 it must display red.

If column A says "in progress" it must remain white.



Can anyone help

thanks very much.


Nathan

[eluehmann]

ok try this:
Columns A,B&C

Completed...............1/25/2005................9
Inprogress...............1/30/2005................4
Completed...............1/15/2004................385.3516113

Highlight from A1 to C3

Fomat -> conditional formatting

Condition 1:
Formula is: =AND(($A1="completed"),($C1>10))
Make background color red

Condition 2:
Formula is: =AND(($A1="completed"),($C1<10))
Make background color yellow

This will highlight the whole row with the colors your specified

The formula in Cells C1 and down should be: =now()-B1

How is this? You, or I, can tweak if it is not desired results.