| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making a date go red, if date passes todays date.
I want to be able to enter a future date that would be black when entered,
and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making a date go red, if date passes todays date.
Yes. Look up "conditional formatting" in Excel help.
-- David Biddulph "Jamie" wrote in message ... I want to be able to enter a future date that would be black when entered, and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making a date go red, if date passes todays date.
Use conditional formatting with a formula of =A1<TODAY()
-- __________________________________ HTH Bob "Jamie" wrote in message ... I want to be able to enter a future date that would be black when entered, and then go red when that date passes. (to show urgent/out of date work). Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| How can I get an age using todays date and date of birth? | Excel Discussion (Misc queries) | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
| how can I set an alarm for when a date passes? | Excel Discussion (Misc queries) | |||
Linear Mode
