You would have to put the conditional format formula into cell C2.
and it would be the active cell when you code the formula.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"rsmith" wrote in message ...
Hi there

I would like to copy conditional formatting in one cell (i.e. that says
format C1 if is isn't equal to A1) to another row - say row 2. Instead of the
conditional formatting now saying if C2 isn't equal to A@ then format, it
just keeps it referring to A1 as in the first formula.

Is there any way to get it to change the row number accordingly, (as excel
does with other regular formulas) rather that having to go into each cell
individually and changing the numbers?

Any help would be greatly appreciated!