@_@ Wow.....please tell me there's an easier formula or even better if
anyone knows a good link I can use to look up the information myself. (The
Excel help menu gave me nothing).

As for the Paste Special function, it didn't work for me. I'm probably just
missing something so if anyone has any other ideas, or links, I would
appreciate it.

Thanks for your info nastech! :)

"nastech" wrote:

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?