Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF OR RANGE CONDITIONING | Excel Discussion (Misc queries) | |||
Conditioning?? | Excel Worksheet Functions | |||
cell conditioning | New Users to Excel | |||
conditioning | Excel Worksheet Functions | |||
help with cell conditioning? | Excel Worksheet Functions |