I thought I could do this by putting the days value into a shared variable, reading the shared formula into another formula and changing the background of the D H M field based on the second formula field.

 

This works except....

The days value for record 1 is rolling over into record 2... for example

 

record 1 is showing 4 days

record 2 is showing 2 days

my threshold is 3 days

 

Record 1 should be higlighted and record two should not, but record 2 is being highligted as the days value of 4 in this example is being carried over from record 1 to record 2

 

Can someone please explain why this is and how I can fix it?

 

Thanks in advanced