Auto-filter horizontally column wise on basis of date

[shoaib1989]

Dear Sir/Madam,

I am having a problem while filtering column wise instead of row wise on the basis of current date.

 

[Matt Allington]

You will need to explain yourself a bit better

 

[shoaib1989]

I have a sheet with the month feb,2016 from 1st to 28. I used conditional formatting for looking different if cell posses today's date. Now on-wards, I want to auto-hide/filter on the basis of today's date/different color format without using macros.

 

[Matt Allington]

I don't think this is a power bi topic. You would probably be better to post in the general Excel forums