Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to have a validation done between two date columns in which the
user will be flagged if one date is over 90 days.Is there a way to have either one or both date columns turn color, blink or flag user on this parameter? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Format=Conditional Formatting
Debra Dalgleish's site has information on both conditional formatting and data validation if you want to prevent the entry of the offending date. http://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "jk" wrote in message ... I am trying to have a validation done between two date columns in which the user will be flagged if one date is over 90 days.Is there a way to have either one or both date columns turn color, blink or flag user on this parameter? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Current time Current date. | Excel Programming |