Windows 7 - Find & Replace Cell Colors

Asked By bbagb

28-Jan-10 02:34 PM

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Is there any way to find and replace cell colors in Excel? I know you can do this in Excel for PCs but is it an option for Mac users?

28-Jan-10 04:18 PM

this format, some or all of this message may not be legible.

--B_3347540289_42178790
Content-type: text/plain;
charset="US-ASCII"
Content-transfer-encoding: 7bit

On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0,

No, sorry you can not do this directly in Mac Excel. However, you can add
another column to represent the colors, and search based on its value.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom


--B_3347540289_42178790
Content-type: text/html;
charset="US-ASCII"
Content-transfer-encoding: quoted-printable

in article <a href=3D"59bb1c81.-1@webcrossing.JaKIaxP2ac0">59bb1c81.-1@webcro=
ssing.JaKIaxP2ac0</a>, "<a href=3D"bbagby@officeformac.com">bbagby@office=
formac.com</a>" <<a href=3D"bbagby@officeformac.com">bbagby@officeform=
r: Intel Is there any way to find and replace cell colors in Excel? I know y=
ou can do this in Excel for PCs but is it an option for Mac users?<BR>
e:10pt'>No, sorry you can not do this directly in Mac Excel. However, you ca=
n add another column to represent the colors, and search based on its value.=
TYLE=3D'font-size:9pt'><BR>
-- <BR>
Bob Greenblatt [MVP], Macintosh<BR>
bobgreenblattATmsnDOTcom</SPAN></FONT></FONT><FONT FACE=3D"Lucida Grande"><SP=
AN STYLE=3D'font-size:10pt'><BR>


--B_3347540289_42178790--

28-Jan-10 04:23 PM

No, that feature has not made it into the Mac version.

It may not help now, but if you create Styles to impose formatting the F&R
is unnecessary. The style can simply be modified to change any aspect of the
formatting it calls for and all cell having that style applied will be
reformatted based on the new style definition calls for.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0,

28-Jan-10 05:19 PM

this format, some or all of this message may not be legible.

--B_3347543962_21439185
Content-type: text/plain;
charset="US-ASCII"
Content-transfer-encoding: 7bit

Check the posts under Select Cell by Color, change the if logical from = to


Gene Augustin




On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0,





--B_3347543962_21439185
Content-type: text/html;
charset="US-ASCII"
Content-transfer-encoding: quoted-printable

the posts under Select Cell by Color, change the if logical from =3D to <&=
gt; and change the color range for no color. This may help.<BR>
Gene Augustin<BR>
On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0, "b=
E=3D'font-size:12.0px'>Version: 2008 Operating System: Mac OS X 10.6 (Snow Leo=
pard) Processor: Intel Is there any way to find and replace cell colors in E=
xcel? I know you can do this in Excel for PCs but is it an option for Mac us=
ers?<BR>
LE=3D'font-size:12.0px'><BR>


--B_3347543962_21439185--