Is there a way to copy and paste conditional formatting in the same way that
I copy and paste formula's? (Where Excel changes the cell references
automatically for the row or rows to which the formula is copied.)

I have tried to copy and paste-special (with just the formatting box
checked) and although it copies the conditional format and formula ok; the
cell references within the formula are incorrect for that new row(s).

It seems to increase the column value be one letter. (ie... from L10 to M10)

There are 500 rows to this spread sheet, and although I could write a
conditional formatting statement for each of the cells, it seems that there
should be a faster way.

Hopefully I've worded my request correctly. If not this is what I'm trying
to do:

cell A1=CRT1

cell B1= normally blank, but will display "date check" from a calculation &
an if
statement based on information in only that row

When B1=date check , conditionally change A1 format to yellow background.

Is there a way to repeat this process without all the typing.

Thanks in advance.

metro