sort data with font colour

[annadinesh]

Dear Experts

I have an Excel Sheet and in column F is for Date , we need a filter button which hides the dates are in red colour font code and displays only black colour font code


Regards



Dinesh Saha

 

[pjmorris]

create your data as a Table, from the filter drop down button select filter by colour:

Test data:

Book1
	A
1	Test
2	31-Jan-23
3	10-Jun-97
4	01-May-18
Sheet1

Showing the filter option: