Hello,
I'm hoping someone can provide some code for below task. I've considered using conditional formatting for this but it slowed down the file quite noticeably which was already quite slow to start off with hence deciding on the macro route.
My aim is to highlight date cells appearing in columns N, P, R, T, V, X, Z, AB either in RED or AMBER/ORANGE if they fall into the below date criteria.
Highlight ORANGE - if the date is within 2 weeks of today's date (including today)
Highlight RED - if the date is within 2 weeks before today's date (excluding today)
i.e.
14 days <-----HIGHLIGHT RED------>TODAY<-----HIGHLIGHT AMBER------> 14 days
- Headings are in the first row and the dates start from row 2 and shouldn't populate more than a 1000 rows
- Some cells might be blank
- Macro would clear any highlighting it had previously made in these columns and insert new highlighting when re-activated on say a different day.
I'm hoping someone can provide some code for below task. I've considered using conditional formatting for this but it slowed down the file quite noticeably which was already quite slow to start off with hence deciding on the macro route.
My aim is to highlight date cells appearing in columns N, P, R, T, V, X, Z, AB either in RED or AMBER/ORANGE if they fall into the below date criteria.
Highlight ORANGE - if the date is within 2 weeks of today's date (including today)
Highlight RED - if the date is within 2 weeks before today's date (excluding today)
i.e.
14 days <-----HIGHLIGHT RED------>TODAY<-----HIGHLIGHT AMBER------> 14 days
- Headings are in the first row and the dates start from row 2 and shouldn't populate more than a 1000 rows
- Some cells might be blank
- Macro would clear any highlighting it had previously made in these columns and insert new highlighting when re-activated on say a different day.
