ExcelTips247 on Instagram: "Conditional Bar Chart - Excel Tips and Tricks Learn how to create conditional bar chart. We are essentially coloring a bar based on value in Excel. Here, the steps outline in my video. Marks Less Than 50 =IF(C7 =$D$4,C5 =86 =IF(C5>=F4,C5,"") Draw Bar Chart 1) Select Dataset (exclude headers) 2) Alt+F1 3) Chart Design ~ Change Chart Type 4) Bar 5) OK 6) Resize and repositions 7) Exclude "Mark" column Color Assignment 1) Select gray bar chart series 2) Ctrl+1 3) Fill= G