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.