Conditional Formatting Multiple Axes Chart


I am using Multiple Axes Chart

Axis – DayofMonth

Legend – Month Name

Value Axis 1 – Sales

Value Axis 2 – Sales Forecased

Do we have an option to conditionally format the colors of Month. Like Jan will be pale yellow and so on till December but default color of current month to Red.

Conditional Formatting isn’t working.

Asked question