Find & Replace Cell Colors

[bbagby]

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]

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.

 

[CyberTaz]

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

 

[Gene Augustin]

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