In the attached Hollywood Car Sales Table I would like the cells above any filter cursor drop down arrow (Row 10 - Columns F thru G) to filled with a pink fill #FFA7FF, to indicate that Select All has NOT been checked and one or more of the selections available HAVE BEEN checked. I would like this to happen above all columns.
This will give a clear indication a filter has occurred rather than the small dot at the base of the filter funnel.
I realize this could also be shown using a slicer but I want to do this on another table which has over 20 columns and this to me might be a more practical approach.
Is this possible?
I don?t know how to access the select all field or selector and make this happen.
Bookmarks