Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have two columns: G25 (submission date) & H25 (delivery date - which
defaults to 3 workdays after the submission date). The formula I'm using to generate H25's value is: =IF(G250,(WORKDAY(G25,3,Holidays_08))," ") I want to conditionally format H25 to appear RED if the user manually enters a date that is less than 3 workdays. How can I do this? I have tried setting it myself but just can't get it to work. Thanks for your help -- JoAnn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - Dates | Excel Discussion (Misc queries) | |||
Conditional Formatting-dates | Excel Worksheet Functions | |||
Using Conditional Formatting for Dates | Excel Discussion (Misc queries) | |||
conditional formatting dates | Excel Discussion (Misc queries) | |||
Help with Conditional formatting with Dates | Excel Discussion (Misc queries) |