How to filter datacolumn in excel using header color

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.

Thank you

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


ok, then i think would be better to use macros: