Formula for conditioning a cell
 

If I am wanting to take a date in Cell B3" (20081231) and make it
automatically change to red if it is past that date, what formula or process
would I have to do?

If that same date is within 30 days out, would it be the same process?

Formula for conditioning a cell
 

Use Format | Conditional Formatting
Formula Is =B3<TODAY() then pick format

Formula Is =TODAY() - B3 30 then pick another format

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Wiglog" wrote in message
...
If I am wanting to take a date in Cell B3" (20081231) and make it
automatically change to red if it is past that date, what formula or
process
would I have to do?

If that same date is within 30 days out, would it be the same process?

Formula for conditioning a cell
 

If your B3 cell is a number then to convert to a true date you will have to
enter(somewhere):

=DATE(LEFT(B3,4),MID(B3,5,2),RIGHT(B3,2))

Then you can work on the resulting cell (above) which is now a true date.

"Wiglog" wrote:

If I am wanting to take a date in Cell B3" (20081231) and make it
automatically change to red if it is past that date, what formula or process
would I have to do?

If that same date is within 30 days out, would it be the same process?