Prev: Arrange Footer
Next: retrieve data from different workbook
From: Newsgal on 8 Feb 2010 18:04
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.?
From: Don Guillett on 8 Feb 2010 18:11
Need a macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Newsgal" <Newsgal(a)discussions.microsoft.com> wrote in message
news:F6AAF6C9-15D9-42AD-BAD6-B95FA69B7645(a)microsoft.com...
> 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.?

From: Gord Dibben on 8 Feb 2010 18:59
One method.........................

Select all cells.

Edit>Find>Format>Format>Pattern.........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
<Newsgal(a)discussions.microsoft.com> 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.?

From: Ashish Mathur on 8 Feb 2010 19:15
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" <Newsgal(a)discussions.microsoft.com> wrote in message
news:F6AAF6C9-15D9-42AD-BAD6-B95FA69B7645(a)microsoft.com...
> 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.?

From: Rick Rothstein on 9 Feb 2010 04:21
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" <Newsgal(a)discussions.microsoft.com> wrote in message
news:F6AAF6C9-15D9-42AD-BAD6-B95FA69B7645(a)microsoft.com...
> 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.?

 | 
Pages: 1
Prev: Arrange Footer
Next: retrieve data from different workbook