Conditional format column chart in Excel

00:00 Conditional format charts (columns change color based on value)
00:15 Chart data setup- hidden series for each season
01:35 Create the column chart with the conditional formatting
02:00 Hide the unused series in the chart
02:19 Change colors (green for summer, brown for winter)
02:50 Change the data, chart series changes color
03:12 Show years and months as 2 level axis

Make your Excel charts conditional formatted in that the columns change colors depending on what the number or category is, and when the data changes the colors will also change.