more conditional formatting

[Ross]

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

 

[Guest]

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]

I tried that -- put =now() in cell AA3 and selected cell f2. Went to
conditional formatting, chose formuala from dropdown and put in formula:
="$AA3-f4>60" , formatted text to turn red, hit enter and nothing happened.
It should have, because the referral date in E2 was 3/25/05, but the date in
F2 did not change color. Also, since I already have a formula in all of
column F -- =E2+60 that has been pasted in that whole column. How can I
paste the conditional formatting in the same column?
Ross

 

[Guest]

Dates are always fun

First try putting numbers in the cells that are > 60 different to see if
you got the conditional formatting to work (format for numbers)

Then return to dates and be sure that both cells are formatted for teh same
date format - canchange later if you need to

Then $AA4 needs to be $AA$4

As to copy/fill ,My mistake, i don't do conditional format often

block entire format region
cell value is > Greater than > =$AA$4 + 60
Format.....

That should work