| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating For a Date
I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I would like the text or the cell to be highted to a color. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating For a Date
Use the following formula in FORMULA is
=(A1-Today())730 assuming your dates are in Col A "Dan" wrote: I would like to set a conditional format for a date, day-month-2 digit year. If I enter any give date in a cell, and once that date exceeds 2 yrs, then I would like the text or the cell to be highted to a color. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating For a Date
Will this still work even if they are not todays dates. Some of these dates
go back a yaer or so. "Sheeloo" wrote: Use the following formula in FORMULA is =(A1-Today())730 assuming your dates are in Col A "Dan" wrote: I would like to set a conditional format for a date, day-month-2 digit year. If I enter any give date in a cell, and once that date exceeds 2 yrs, then I would like the text or the cell to be highted to a color. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating For a Date
Yes. Today() gives you the today's date and then compares it with the date in
A1 NOTE: I gave you the wrong direction. Pl. use =(Today() - A1)730 Use 731 Iinstead of 730) if you want to take care of leap year... "Dan" wrote: Will this still work even if they are not todays dates. Some of these dates go back a yaer or so. "Sheeloo" wrote: Use the following formula in FORMULA is =(A1-Today())730 assuming your dates are in Col A "Dan" wrote: I would like to set a conditional format for a date, day-month-2 digit year. If I enter any give date in a cell, and once that date exceeds 2 yrs, then I would like the text or the cell to be highted to a color. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating based on Date | Excel Worksheet Functions | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional formating w/ Date | Excel Worksheet Functions | |||
Hybrid Mode
