conditional formatting

[Guest]

How do you copy conditional formatting to other cells without the reference
cell location being locked in? In other words, if I place a conditional
format in cell E1 which references to values in cell A1, how do I copy this
to cell E2 and reference to A2 not A1?

 

[Guest]

get rid of the '$' infront of the letter (column) and/or number (row) inside
the cond. formatting.
the '$' makes it absolute