Replace filled color

[Marina_Zhang]

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!

[#2]

@Marina_Zhang 

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

[#3]

Thank you so much! @Hans Vogelaar 

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

[#4]

@Marina_Zhang 

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

[#5]

I see. Thanks!