Knowing that it can't be done also saves a lot of time. Thanks for answering.

--
eugene


"Jim Thomlinson" wrote:

There is no easy way. I am affraid you have to loop through all of the cells.
--
HTH...

Jim Thomlinson


"eugene" wrote:

Hi,

I have a random group of cells in a range whose background color is blue. I
would like to change the background color of all these cells. I know that
this can easily be done with a loop that searches for colored cells and makes
the change when found.

I am wondering, though, if there is any neater way to do this, maybe using
a range command or something similar - i.e. for all cells in myRange that
are colored blue, change the color to red. Any thoughts if this is possible
and how it might be done.

--
eugene