Re: How to change data in a cell, based on the date

Tech-Archive recommends: Fix windows errors by optimizing your registry


Rangerbob86,

You can use conditional formatting. Select a cell where your dates are
say
A1 then click on the Format menu. Select Conditional Formatting.
Change the Cell value is option to Formula is: For Condition one try
this if your date is less than 5 days from today.

=(A1-TODAY())<5

Select Format>Patterns and select your color. Click OK and OK. Copy
the format to the other cells in your range.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread: http://www.excelforum.com/showthread.php?threadid=552429

.