ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting VBA Routine (https://www.excelbanter.com/excel-discussion-misc-queries/264529-conditional-formatting-vba-routine.html)

1brad19

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