conditional formatting

  • Thread starter Donald Flanders
  • Start date
D

Donald Flanders

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?
 
U

ufo_pilot

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