Workday function and Conditional formatting.. Can you solve this?

[Steve Kay]

Hi,

I am just learning some basic tricks with "conditional
formatting" However, am having a problem... can anyone
help?

Here is what I am trying to do. (simple terms)

Cell
A1 03-Feb-03
B1 If this cell is greater than 3 working days from today
and there is no entry turn red.
If this cell has an entry and the date is greater than
3 days turn yellow.

Can you or anyone help?

Thanks a million! I have been searching through text
books and then discovered this site.. I am a novice
user.. so please be gentle.. and I am sure its toooo easy
for most of you... Thanks

 

[Peo Sjoblom]

Do insert>name>define

in the formula box put

=NETWORKDAYS(Sheet2!$A$1,TODAY())

call it something like MyFormula, click add and OK
Now in B1 use format>conditional formatting, formula is

=MyFormula>3

select the format and click OK twice

This is because networkdays is part of the ATP and
cannot be used directly in CF (it resides on another sheet)
Note also that the function has an optional range for holidays (see help)