How to filter datacolumn in excel using header color

Learn Academy Feedback
, , ,
#1

Hi All,
I have one excel file. in that excel i am using filter table on that table using header color i want to delete the column datas in excel.

Capturelkdsjfj
Capturelkdsjfj1130×570 45.9 KB

Thank you

#2

Hi, do you want to delete all columns in your excel if the header is yellow?

#3

yeah

#4

ok, then i think would be better to use macros:
https://analysistabs.com/vba/vba-delete-columns-based-cell-color-excel-macro-example-code/