Conditional Formatting with Dates

  • Thread starter Thread starter JoAnn
  • Start date Start date
J

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
 
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
 
Thanks! I've got it working now.
--
JoAnn


Bernie Deitrick said:
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
Click to expand...
 
Back
Top