| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cell if date not current
I am trying to figure out if the date in a cell can be formatted to red if it
is a date that is prior to today's date. Can this be done and if so, how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format cell if date not current
Conditional Formatting (Format-Conditional Formatting) should be the
best thing. "Formula Is" =(your cell)<today() <- evaluates to TRUE Format... (change font color to Red) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format cell if date not current
Format/ Conditional Formatting/ Cell Value Is/ Less than/ =TODAY()
Choose your red format. -- David Biddulph "Becky" wrote in message ... I am trying to figure out if the date in a cell can be formatted to red if it is a date that is prior to today's date. Can this be done and if so, how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tag a cell with current date | Excel Discussion (Misc queries) | |||
| Date label and current date in same cell | Excel Discussion (Misc queries) | |||
| conditional format by comparing to current date | Excel Worksheet Functions | |||
| current Date and time in cell | Excel Discussion (Misc queries) | |||
| Show current date in cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
