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) |