No you cannot, however one could put these 3 formulas somewhere off the
visible sheet like in IV1:IV3 or wherever
then use formula is and


condition1 =$IV$1
condition2 =$IV$2
condition3 =$IV$3


then it will work

--


Regards,


Peo Sjoblom

"Ron Rosenfeld" wrote in message
...
On Wed, 13 Aug 2008 08:26:22 +0100, "Bob Phillips"
wrote:

Three conditions will do it

Condition 1 formula: =NETWORKDAYS(A4,TODAY())=5
Condition 2 formula: =NETWORKDAYS(A4,TODAY())=3
Condition 3 formula: =NETWORKDAYS(A4,TODAY())=1

--
HTH

Bob

Bob,

Will NETWORKDAYS work in conditional formatting in pre-2007 versions?
--ron