Is there a formlula to replace cell shade color with another color

Is there a Find and Replace type of formula where which will find cells with
a formatted with one pattern color and replace them with a new pattern color.?

Need a macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Newsgal" wrote in message
...
Is there a Find and Replace type of formula where which will find cells
with
a formatted with one pattern color and replace them with a new pattern
color.?

One method.........................

Select all cells.

EditFindFormatFormatPattern.........pick the pattern and "find all"

After the finding and with the "found" dialog still open hit CTRL + a to
select the founds.

Format to new pattern.


Gord Dibben MS Excel MVP

On Mon, 8 Feb 2010 15:04:01 -0800, Newsgal
wrote:

Is there a Find and Replace type of formula where which will find cells with
a formatted with one pattern color and replace them with a new pattern color.?

Hi,

This will work as long as those cells are colored manually as against
colored via conditional formatting

1. Select the range which has the colors to be replaced;
2. Click on Ctrl+F Options Format Choose format from cell
3. Select any one cell which has the format
4. Click on Find All and then press Ctrl+A
5. This will select all the cells which have that format
6. Now press Ctrl+1 and choose the desired format

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Newsgal" wrote in message
...
Is there a Find and Replace type of formula where which will find cells
with
a formatted with one pattern color and replace them with a new pattern
color.?

You can't do that with a formula, but you can do it with Excel's Replace
functionality. Click Edit/Replace on the menu bar or, alternately, press
Ctrl+H to bring up the Replace dialog box. Click the "Options" button to
display all the available option if they are not already displayed. Leave
the "Find what" and "Replace with" fields empty. Click the Format button to
the right of the "Find what" field, click the Patterns tab and select the
color you want to replace. Next, click the Format button to the right of the
"Replace with" field, click the Patterns tab and select the color you want
to replace it with. Finish off by clicking "Replace All" button. The above
procedure will perform the replacement throughout the active worksheet... if
you want to restrict the color replacements to a certain area of the active
worksheet, select a range that encompasses those cells first, then follow
the above procedure.

--
Rick (MVP - Excel)


"Newsgal" wrote in message
...
Is there a Find and Replace type of formula where which will find cells
with
a formatted with one pattern color and replace them with a new pattern
color.?