Forum Discussion
Solved
Creating a shortlist from conditional formatting or date range across multiple columns
So I have a table with a list of key dates for clients. First columns are client name, then there's 8+ columns with various dates that are important. I have used conditional formatting to highlight c...
Davidm54 I would use Power Query for this. No VBA needed. First unpivot the raw data and add a conditional column that checks every date against the rule of today plus or minus 14 days, and filter only those that qualify. Then load back to Excel and apply the CF rules if you want to add the colours. Expand your raw data table and refresh the query.
See attached.
This needs VBA macro,, if you are comfortable with it then edit your post & add the request !!