Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find & Replace Cell Colors

1,593 views
Skip to first unread message

bba...@officeformac.com

unread,
Jan 28, 2010, 2:34:33 PM1/28/10
to
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?

Bob Greenblatt

unread,
Jan 28, 2010, 4:18:09 PM1/28/10
to
On 1/28/10 2:34 PM, in article 59bb1...@webcrossing.JaKIaxP2ac0, "bba...@officeformac.com" <bba...@officeformac.com> wrote:

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?
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

CyberTaz

unread,
Jan 28, 2010, 4:23:10 PM1/28/10
to
No, that feature hasn't 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 59bb1...@webcrossing.JaKIaxP2ac0,
"bba...@officeformac.com" <bba...@officeformac.com> wrote:

Gene Augustin

unread,
Jan 28, 2010, 5:19:21 PM1/28/10
to
Check the posts under Select Cell by Color, change the if logical from = to <> and change the color range for no color. This may help.


Gene Augustin





On 1/28/10 2:34 PM, in article 59bb1...@webcrossing.JaKIaxP2ac0, "bba...@officeformac.com" <bba...@officeformac.com> wrote:

0 new messages