conditional formatting

[Markathepub]

how do I copy the conditional format to another cell without the formul
changing?

When I cut and paste the format, Excel automatically changes the row o
column number and on this occasion I don't want this

I have over 1000 cells to do with most cells conditional format formul
pointing to one other cells value. I am having to edit each cel
individually.

 

[Jason Morin]

Place $ around the cells to freeze rows and/or columns.
Example:

Relative:
A2
Mixed (freeze col.):
$A2
Mixed (freeze row):
A$2
Absolute (freeze row & col.):
$A$2

You can click inside the cell reference and press F4 to
cycle through the different options.

HTH
Jason
Atlanta, GA