Date Change color the text of field

[mlopez60120]

I created a file to help me manage number of days between dates. It works well. I need help to identify when the dates changes and it adds days maybe one color or when dates are reduced make it another color. In the attached file has a sample it contains column A and B and the dates are calculated on column D. When the a Date is added in the Actual date I need to recalculate the dates in column D and if the date increase highlight one color and if the date decreases make it a different color.

[etaf]

just to clarify
if the calculation of B-A is less than C-A you want Colour1
if the calculation of B-A is greater than C-A you want Colour2

two conditional format rules

one using
=AND(C2<>"",(B2-A2)>(C2-A2))

and second using

=AND(C2<>"",(B2-A2)<(C2-A2))

if it equals theres no colour

[protonLeah]

Calculate col D:

Please Login or Register  to view this content.

conditional format Col D
Early: =D2<0
Late/pending:
=D2>0

[mlopez60120]

Thanks this works perfect Thanks