Conditional Formatting with Dates

[JoAnn]

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(G25>0,(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

 

[Bernie Deitrick]

JoAnn,

You cannot use WORKDAY in a CF - since it is a Analysis ToolPak function.

You could use a hidden column that calcs the correct date, and compare the
manually entered date to that.

HTH,
Bernie
MS Excel MVP

 

[JoAnn]

Thanks! I've got it working now.
--
JoAnn

JoAnn,

You cannot use WORKDAY in a CF - since it is a Analysis ToolPak function.

You could use a hidden column that calcs the correct date, and compare the
manually entered date to that.

HTH,
Bernie
MS Excel MVP