HIghlighted range dependent on month selected

HI all.
If anyone can help me get started that would be great. I don't know if there is an easy way but here is what I have:

Year-To_date = 4 ' select from drop down box tied to cell b3.

[Jan Feb Mar Apr May etc.
10 20 100 70 8

The user would select a month in numeric format from the drop down box above....in this case 4. Then the rows would highlight in a color (light green) to include the months and the numbers below from Jan up to and including the month selected...in this case 4.

I don't think conditional formatting would work since it is tied to a cell value and in this case the cells have an abbreviated month in them, while the drop-down has a number representing a month in it. Would a macro tied to the drop-down box be key to highlight both rows? Any idea on the macro? Much thanks.

v

Hi,

try this: Month.xlsm

Please note: when the months are listed in a different column than in the file or the first row of data is different you have to adapt this in the code.

Mark this thread SOLVED and click the star if this answer solves your problem.

Regards

Hi,

try Month(1).xlsm

Regards

Hello tehneXus,

I like your signature, very clever!