Filter Cell Color

New Contributor

I am sharing a excel spread sheet and trying to filter by cell color. It works unshared but as soon as i enable sharing, the option is disabled. Is there a fix for this?

2 Replies

 How to filter or select cells by cell color in Excel?

a none Microsoft site

 

Add Info:

Filter by font color, cell color, or icon sets

Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011

 

Welcome to your Excel discussion space!

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

@charlesmay

@NikolinoDE Your information is helpful, I just do not have access to those options under the filter tab while the file is in "Shared" mode. that is the fix I'm looking for. Additionally, i do not want to download and install several apps just to restore this function. If it is not possible to filter by cell color while sharing a document, i will need to find a workaround.