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.

maybe i think you need to cut n paste cell D10 to I10...
but verify if I10 is linked to wherever.
--
*****
birds of the same feather flock together..



"cstwoplus" wrote:

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.

D10 and I10 are completely different values, so that won't work, but thanks
for trying.

"driller" wrote:

maybe i think you need to cut n paste cell D10 to I10...
but verify if I10 is linked to wherever.
--
*****
birds of the same feather flock together..



"cstwoplus" wrote:

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.

cstwoplus,

=D$10<ROW()-ROW($D$93)

Although you could shorten this to =D$10(ROW()-93, it would get damaged if
the cells got moved, like from an insert or delete.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"cstwoplus" wrote in message
...
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.

Two weeks later and I finally got to try it. It works great! Thanks!

"Earl Kiosterud" wrote:

cstwoplus,

=D$10<ROW()-ROW($D$93)

Although you could shorten this to =D$10(ROW()-93, it would get damaged if
the cells got moved, like from an insert or delete.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"cstwoplus" wrote in message
...
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.