Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

@Marina_Zhang 

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? 

@Marina_Zhang 

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

I see. Thanks!