Conditional Formats for Bar Charts
Click on an item in cloumn A to see the Chart for that item Click anywhere else to hide the chart Set condition limits for the data range below Green shading above 40 units Red shading below 30 units Yellow shading in between You can change the limits in the cells at left, and you can change the conditional colours. Click the Set button when finished
Set
Month Conditional Formats Meat Fish Veggies
50 40 30 20 10 0
Jan 27 28 30
Feb 29 32 31
Mar
Apr
May
Jun 45 29 26
Jul 47 40 42
32 38 41 47 48 26 Conditional Formats - Meat 43 29 31
Jan
Feb
Mar
Apr
May
Jun
Jul
change the limits in the cells at ou can change the conditional
Set button when finished