Sep 23 2022 04:52 AM
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?
Sep 23 2022 06:59 AM
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.
I know I don't know anything (Socrates)
Sep 23 2022 10:16 AM
@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.