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