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

  1. Select "Manage Rules" under "Conditional Formatting," which is found under the "Home" tab in Excel:
  2. conditional formatting.

  3. Next, open the "Edit Formatting Rule" window and select "Format" and "Fill." Select your color, press "OK," then "Apply."
  4. edit rules

    format fill color

  5. Repeat this for all (3) rules found in the template.

To Change the Color on Specific Parts of the Bar

  1. Select the cells you wish to change the color of. Then, select "New Rule" under "Conditional Formatting"
  2. 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 _."
  3. Lastly, select your color through the "Format" button, press "OK," then "Apply.

    set new conditional formatting rule


Isn't it Time to Upgrade Your Excel Charting Skills?

Stop trying to make your spreadsheets easy to read. Nobody wants to read your spreadsheet!
And stop using primitive line, pie and bar charts.
Isn't it time to graduate to Smart Charts: Control Charts, Pareto charts and Histograms?

spreadsheet
Spreadsheets
primitive charts
Primitive Charts
smart charts
Smart Charts

Stop Struggling with Excel Charts!
Start creating Smart Charts in just minutes.

Download a free 30-day trial. Get Smart Charts for Excel now!

SPC Charts Included in QI Macros for Excel