Hi Guys

I have setup up a formula to work out out how many days there are
between today's date (continually updating using today() function) and
the due date for my assignments.

The formula works fine and the result within the cell is appended with
"days" at the end. Once there are 0 days left "complete" will be
dispalyed in the cell.

No problems there, formula is pasted below:

=IF(('Assessment schedule'!J4-TODAY())<=0,"Complete",'Assessment
schedule'!J4-TODAY()&" days")

The strangeness starts when I try to apply conditional formatting to
these cells.

I applied a conditional format to all cells with a value of less than
30 days which works fine until the value (number of days) drops to less
than less than 10 days!!

Between 30 days and 10 days the conditional formatting is applied. as
soon as the number of days reaches 10 each cell reverts back to default
formatting.

I have even tried to apply an additional condition which should apply
formatting to cells with a value equal to or less than 10 days but this
does not work either.

I can change the due date of for each assignment in the assignment
schedule worksheet so the value is between 10 and 30 days and the
formatting works fine but as soon as that date is changed to return a
value of less than 10 days it reverts back to default formatting.

I am stumped :(

any help you guys can offer would be greatly appreciated

Cheers

Chris


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