How does Excel use color to identify numbers?

As shown in figure:

　　Office Tutorials How do Excel use colors to identify numbers?

In fact, this is the conditional format, but Excel2007 and Excel2010 version of the unique features.

Now that you know it's a conditional format, of course you find style in start, conditional formatting, and then choose Data Bar, gradient fill.

If you are not satisfied with the default colors, you can also modify them yourself.

Of course, if you want to get one from the new rule and make changes to some of the settings in it, no one is against it.

However, if you still use although old but Classic 2003 edition, is not only hope and sigh?

Not really, we can find a workaround, with a rept function with the cell font color settings can also achieve similar effects:

=rept ("█", INT (c3/2.5))

Note: The formula "/2.5" is based on the size of the data and color bar length to match, if the data is large or color bar is very short, it is necessary to remove a little more, the other is less or even can use multiply

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join