Forum Discussion
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 right side. Does anyone face the same issue and how do you deal with it? Thanks!
Excel for Mac does not support finding and replacing formatting; that is only available in Excel for Windows.
Thank you so much! HansVogelaar
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.
