can cells apply conditional formatting using the internal clock?

  • Thread starter Thread starter Dan Kuzmanovic
  • Start date Start date
D

Dan Kuzmanovic

I am using excell to keep track of my production schedule
and I wanted to know if there was a way to tie the cells
in a worksheet to the internal date and time in the
computer,so that the cells will update automatically.
Example: Row A10 would be my production start date, Row
A1 would be my projected finish date, I would like the
cells in between to go from green to red as I near the
finish date without manually inputting the date in each
cell. Can you help me? Thyanks
 
Set the normal format as desired (I selected a Pattern of Green).

Select A1:A10, then select Format | Conditional Formatting... Set the
first drop down to Formula Is. In the 2nd text field enter
=($A$1-$A$10)/ROWS($A$1:$A$10)*(ROWS($A$1:$A$10)-ROW())+$A$10<=TODAY()

Click the Format... button and set the format as desired (I chose a
Pattern of red).

For test purposes, I used $C$1 instead of TODAY(). Then, I changed C1
to different dates and watched as A10->A1 turned from green to red.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
Back
Top