Hi

That URL doesn't work for me.

Andy.

"christopherp"
wrote in message
news:christopherp.248vdn_1141642500.8698@excelforu m-nospam.com...

Hey guys thanks for responding.

I have attached a screen shot so you can see exactly what is going on.

I don't want to change the CF between 10 and 30days, all I want to do
is CF all the cells in the same manner once the due date is within the
thirty day threshold.

All works fine until the difference between the due date and today() is
less than 10 days at which stage it reverts back to default format.

See cells c13 and c19 for an example.

All cells in the "C" column are CF'ed the same.

Hope this helps us solve the mystery

Chris


+-------------------------------------------------------------------+
|Filename: conditional formatting.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4420 |
+-------------------------------------------------------------------+

--
christopherp
------------------------------------------------------------------------
christopherp's Profile:
http://www.excelforum.com/member.php...fo&userid=4162
View this thread: http://www.excelforum.com/showthread...hreadid=519266