See Conditional Formatting under the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"RJM" wrote in
message ...

If I were to assign "=NOW()" to say...cell A10 and have column
C
dedicated to delivery dates for customers, could I have the
cells
automatically change colors the closer it gets the date in cell
A10?
For instance: If any of the delivery dates were 2 weeks away
then the
cells would turn green, 1 week away those cells would turn
limegreen, 3
days away they would turn yellow and past due would be red.
Thnx for any
help


--
RJM
------------------------------------------------------------------------
RJM's Profile:
http://www.excelforum.com/member.php...o&userid=24822
View this thread:
http://www.excelforum.com/showthread...hreadid=551179