You need to look at the difference between relative and absolute addressing,
and adjust the $ symbols accordingly.
--
David Biddulph

"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!