Replace filled color

Copper Contributor

Hi, I was trying to use find&replace according to change the refilled color. After selecting "Options", it does not showed as many people did. It does not have the "Preview". It shows nothing on the right side. Does anyone face the same issue and how do you deal with it? Thanks!

Screen Shot 2023-09-22 at 10.59.38 PM.png

4 Replies


Excel for Mac does not support finding and replacing formatting; that is only available in Excel for Windows.

Thank you so much! @Hans Vogelaar 

Do you know how to use other functions to replace the filled color for MAC users? 


It can be done using a VBA macro, but it requires you to be familiar with Excel VBA.

I see. Thanks!