conditional formatting
 

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?

conditional formatting
 

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

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?