The attached image shows a combination of line and bar chart. The named-range called CurrMthCol may contain numbers from 1 to 24 (a two year period).
In the attached image, because it contains Agust 2013 (or 8), its matching bar is shaded (filled) red.
For your consideration, Agust 2014 will be 12 + 8 or 20.
Question: Using VBA or whatever possible, how can I shade the bar matching the value in CurrMthCol?