Forum Discussion
How to enable the Filter by Color
How to enable the Filter by Color? The Date Filter, the Number Filter and the Text Filter are available, but there is no Filter by Color option for me in Excel Online.
4 Replies
- Please check this Microsoft Link
https://support.microsoft.com/en-us/office/filter-by-font-color-cell-color-or-icon-sets-4af3e865-3e34-4d81-9814-1893ffaada3c#:~:text=On%20the%20Data%20tab%2C%20click%20Filter.&text=in%20the%20column%20that%20contains,and%20then%20click%20the%20criteria.- Hi Sivakumarrj!
Thanks but I have tried that already. I was looking online for possible solutions but none have worked so far.
There is no Filter by color option, it's not even shaded out in grey where you can see it. I'm using Excel for the Web (Excel Online). Is this Filter by color not available in this version?
It took me awhile even to get the Filter by date. The Filter by date only appeared when I changed the date format from Day/Month/Year to Month/Day/Year.
How can I get the Filter by Color option??- Try Filter with custom sort and select cell color or font color under "sort on". Lets' hope it should work.
