I'd guess that your data isn't what it appears to be.

Maybe you're looking at the wrong cells. Maybe the dates are text (and not
really dates). Maybe the dates aren't what you think they are (give them an
unambiguous format: dd-mmm-yyyy) to check.

wrote:

Okay this works good, it does take a few seconds to update, but I'm
okay with it.Thanks.....
But, the cells in this range have stopped refering to the AND
statement below ...

=IF(AND(N$2=$K7,N$2<=$L7),IF($G7="On Track",2,IF($G7="Issues",
3,IF($G7="At Risk",4,IF($G7="Completed",5,1)))),"")

there is a begining date and an ending date for each row. In the
range N7:is66 each cell represents a day. if the day that each cell
represents doesn't fall between the date range, then it is not
colored. The code you helped me with stopped doing this. It's
ignoring the dates that the AND statement is refering to above....

Adam

--

Dave Peterson