Excel – How to format data bars based on value in Excel 2010

Select the entire range (using your example, B1:B10).
Add a new conditional formatting rule.
Select Use a formula....

the formula you use should be =(B1>=A1) (or =(B1<A1) for the red)
you will have to type this, as using arrows or clicking on the cells will insert a fixed reference with $ signs, which we have to avoid. Use the Format button to change the color (fill color for the example).

Now when you click OK, you will see the color change for the entire range based on the value next to them, rather than a fixed value you get when clicking on cells

First, you need to create the chart, and whenever you're done. You only need to select the Status column and go to Home tab, and use Conditional Formatting to make the proper fill and font colors on cells based on a specific text.

To do that, you will need to go to the Conditional Formatting and then choose Manage Rules.

From the Manage Rules dialog, add a New Rule.

From the New Formatting Rule dialog, Do the following:

• Select a Rule Type : Format only cells that contain
• Edit the Rule Description: Specific Text | containing | "Your Status"(put your status between quotes)
• Then, click Format button and choose the proper colors you need, then click OK.
• Now, click OK.

Repeat the steps until you cover all status. Then, click OK and you're done.

Here is an example of what it will looks like :

As you can see, I created the chart first, then I added 5 rules on the column A:A for each word same steps that I explained earlier, and then match the cells colors with the chart colors. The total table is just to get the total number of each status, which I used to create the chart. (I used SUMIF to sum all numbers with matched status)