Forum Discussion
Marina_Zhang
Sep 23, 2023Copper Contributor
Replace filled color
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 ...
HansVogelaar
Sep 23, 2023MVP
Excel for Mac does not support finding and replacing formatting; that is only available in Excel for Windows.
- Marina_ZhangSep 23, 2023Copper Contributor
Thank you so much! HansVogelaar
Do you know how to use other functions to replace the filled color for MAC users?
- HansVogelaarSep 23, 2023MVP
It can be done using a VBA macro, but it requires you to be familiar with Excel VBA.
- Marina_ZhangSep 27, 2023Copper ContributorI see. Thanks!