I have conditional formatting set up for many cells based on a formula like
this:
cell I93 conditional format is =$D$90<0
cell I94 is =$D$90<1
cell I95 is =$D$90<2
etc...an absolute reference and an incrementing value
Now I have to change the reference from $D$90 to $I$90. Is there a way to do
it en masse? If I change the first cell and then use use format painter on
the other cells, I lose the incrementing value. Can I write it differently?
Thanks in advance for any help you can give.