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: