add one cell to your sheet - say "A1"
=now()
format as date
use conditional formatting on your Used portion of Column F
in a cell of F - say F4
set the condition to $A$1 - F4 60
change text / background color

copy it down your column

"Ross" wrote:

I have two columns next two each other in columns E and F:

Refferal Date Due date

The referral date is entered in the E column and the formula in the F column
is for example =E3+60 so that a date 60 days after that is shown. What I
want to happen is for the text to change to a different color when the sixty
days have elapsed. Possible?
Thanks
Ross