Hi, some of this may not be what you asked, but what have.. I do not use the
format for cell id that you use, but with work did on dates / formatting
different examples.

Incidently, are you not doing a copy-paste special, formats?
c.f.'s for date passing # days (in reference cell)

=IF(OR(AX9="",BT9="",BT9=0,$AX$4="z"),"",OR((TODAY ()+1)(AX9+AX$5),AND(AX9<"",OR(AY9="",AZ9=""))))

=IF(AND(AY9="",AZ9="",OR(BT9="",BT9=0,$AX$4="z")), "",(TODAY()+1)(AX9+AX$6))

=IF(OR(BT9="",BT9=0,$AX$4="x",$AX$4="z"),"",(TODAY ()+1)(AX9+AX$7))
------------------------------
formula for hand entering a date in another column as: :yymmdd or ;yymmdd
=IF(OR(BT9={"",0}),"",IF(OR(G9="br",AND(LEN(S9)=5 ,MID(S9,5,1)="q")),"b",IF(LEFT(U9,2)=":c","c",IF(A ND(BT9<1,OR(LEFT(U9,1)={":",";"}),ISNUMBER(ABS(MID (U9,2,6)))),
IF(TODAY()DATE(MID(U9,2,2)+100,MID(U9,4,2),MID(U9 ,6,2)-(10+1)),"d",IF(LEFT(U9,1)=";","-","")),IF(RIGHT(CB9,1)="x","z",IF(BT9<1,"?","")))) ))

----------------------
c.f.'s used for above:
=IF(AND(OR(LEFT(U9,1)=":",LEFT(U9,1)=";"),ISNUMBER (ABS(MID(U9,2,6)))),AND(BT9<1,TODAY()DATE(MID(U9, 2,2)+100,MID(U9,4,2),MID(U9,6,2)-3)),AND(LEN(S9)=5,MID(S9,5,1)="q"))

=IF(DX9="","",OR(G9="br",H9="br",DX9="w:",LEFT(U9, 5)=":call",LEFT(U9,5)=";call",IF(AND(OR(LEFT(U9,1) =":",LEFT(U9,1)=";"),ISNUMBER(ABS(MID(U9,2,6)))),T ODAY()DATE(MID(U9,2,2)+100,MID(U9,4,2),MID(U9,6,2 )-(5+1)))))


=IF(OR(BT9="",BT9=0,AND(BT9=1,R9<"c"),LEFT(U9,3) =":ok"),"",OR(R9="c",U9="",LEFT(U9,2)=":?",IF(BT9< 1,NOT(AND(LEFT(U9,1)=":",ISNUMBER(ABS(MID(U9,2,6)) )))),IF(ISNUMBER(ABS(MID(U9,2,6))),TODAY()DATE(MI D(U9,2,2)+100,MID(U9,4,2),MID(U9,6,2)-(10+1)))))

XXXXXXXXXXXXXXXXXXXXXXXXXXXXX

"Will" wrote:

1. I need a my cells containing dates to highlight red when the current date
passes the date within the cell (basically I need to know when things are
behind).

2. How do I copy a conditional format from one cell and have it apply to a
different one (basically I want to do a series). I've even tried using the
special paste tool and selected formating and it still applies to the
original cell and not the new one(ie: format 1 =R5C7 and when copied to row
7, column 7 it will still format to =R5C7 instead of =R7C7). There are no $
in the formula to be removed so it will do a series (I read this in someone
else's post). How can I do this?