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?