![]() |
Conditional Formatting VBA Routine
I'm trying to have conditional formatting for more than 4 conditions. I'd
like to use the VBA code, but I'm not sure where I enter the conditions in the code. For example, I have an array of dates, B2:D20. I want to highlight dates today or older in red, dates that occur within the next week in orange, within the next 2 weeks pink, and within the next month green. If the date is outside any of those ranges (or if it's not a date), I want no formatting. I have zero VBA knowledge, so I don't know where to enter my conditions. Help. |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com