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

Conditional Formatting with Dates
 

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" wrote in message
...
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

Conditional Formatting with Dates
 

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


"Bernie Deitrick" wrote:

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" wrote in message
...
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