You Can Learn to Use Excel's Conditional Formatting
Conditional Formatting Has a Ton of Applications - here are a few
To Change the Color of the Bars on a Gantt Chart
- Select "Manage Rules" under "Conditional Formatting," which is found under the "Home" tab in Excel:
- Next, open the "Edit Formatting Rule" window and select "Format" and "Fill." Select your color, press "OK," then "Apply."
- Repeat this for all (3) rules found in the template.
.
To Change the Color on Specific Parts of the Bar
- Select the cells you wish to change the color of. Then, select "New Rule" under "Conditional Formatting"
- Next, open the "Edit Formatting Rule" window and select "Format only cells that contain." Then, select the cells you wish to change the color of, in "Format only cells with Cell Value between _ and _."
- Lastly, select your color through the "Format" button, press "OK," then "Apply.
Stop using old technology!
Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.
Track Data Over Time
Primitive Chart
![line graph](/images/tool-icons/line-graph.png)
Line Graph
![line graph](/images/tool-icons/line-graph.png)
Line Graph
Smart Chart
![control chart](/images/tool-icons/control-chart-sm.png)
Control Chart
![control chart](/images/tool-icons/control-chart-sm.png)
Control Chart
Compare Categories
Primitive Chart
![pie chart](/images/tool-icons/pie-chart.png)
Pie Chart
![pie chart](/images/tool-icons/pie-chart.png)
Pie Chart
Smart Chart
![pareto chart](/images/tool-icons/pareto-sm.png)
Pareto Chart
![pareto chart](/images/tool-icons/pareto-sm.png)
Pareto Chart
Analyze Variation
Primitive Chart
![bar or column chart](/images/tool-icons/bar-chart.png)
Bar or Column Chart
![bar or column chart](/images/tool-icons/bar-chart.png)
Bar or Column Chart
Smart Chart
![histogram](/images/tool-icons/histogram-sm.png)
Histogram
![histogram](/images/tool-icons/histogram-sm.png)
Histogram