Descriptive Indicator Filter has Been Used

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.

Try,
E4=SUBTOTAL(3,Table1[SalesPerson])
E5=E6-E4
E6=COUNTA(Table1[SalesPerson])
CF formula =$E$5<>0, applies to =$F$9:$G$9

Thanks for the response!

But this request didn’t meet my original request. It is not putting the cells highlighted in pink above the filter drop down row. I want the cells highlighted in pink to be in row 10.

I am modifying my original request to NOT ONLY highlight the cells in row 10 to be pink filled (Color #FFA7FF) if the statement when you put your cursor over the filter funnel or drop down arrow DOES NOT SAY – SHOWING ALL. This means this column has been filtered.

I am attaching a revised version of Hollywood Car Sales RevD. This revised file has two worksheets Table_Example_01 and Table_Example_02. These two worksheets show the results I would like to achieve in cells B10, C10, D10, E10, F10, and G10. These results were achieved manually. I would like this done automatically.

I would like some type of formula in these cells which if the text statement for the drop down arrow DOES NOT SAY (Showing All) the cell will be filled in pink and the word Filtered put in this cell.

Likewise, if the text statement for the drop down arrow DOES SAY (Showing All) the cell will be filled with NO color and the words Showing All entered in the cell.

Sorry for the modification to my request and if my original request wasn’t clear enough. Hopefully this revised request and file will make the results I desire clear.

Is this possible?

Thanks for anyone’s help.

I have no idea how you can do that. Perhaps use Slicers as indicators.

Thanks, I was aware of slicers as an option. I am using this Table as a practice for a larger table with over 20 columns, using slicers for this many columns fields is not an option. I was hoping what I was proposing for this table was possible and could be applied to a larger table, and I could at a quick glance see what columns had been filtered.

Anyway, thanks for taking a shot at this problem I am going to continue to see if I can come up with a solution.

Thank you torachan!!

This does exactly what I wanted it to do. I am not sure what a “macro in the sheet code module” means. I have very limited knowledge of MACROs and Visual Basic. I went to view MACRO and I didn’t see any code.

My goal is to be able to do this on a much larger Microsoft Excel Table with about 25 columns and I would like to be able to do this on this sheet and perhaps other sheets. I will have to do some research on MACROs in the sheet code module to see if I can determine how to transfer this to other worksheets.

I had one minor tweak to the code; would it be possible to change the font color in the auto populated cells to black?

Again, many thanks – I knew there had to be someone out there who could do this.

It is greatly appreciated.

Thank you, I will give it a try.

I did try it on a larger worksheet with over 20 columns and I was able to get it to work with my very limited knowledge of VBA or MACROs.

Thank You This was a Great Help!