Conditional Formatting VBA Routine

1

1brad19

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Converting URLs in comments to Markdown-formatted links 2
Conditional Formatting in Excel 2003 2
Trouble with Find and Replace vba routine 2
Conditional Formatting 2
Conditional Formatting 0
Conditional Formatting Dates Less Than 14 Years Ago 2
Conditional Formatting 4

Top