View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JoAnn JoAnn is offline
external usenet poster
 
Posts: 78
Default Conditional Formatting with Dates

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