Can I show a percent as a fill color

[Guest]

I would like to show percentages as a graphic in a cell rather than a number.
For example if I type in 25% it will fill up the cell a quarter of the way
with a color. If I type 50% then it will fill up the cell half way, etc.

 

[Myrna Larson]

I don't believe this is possible other than by overlaying the cell with a
rectangle, and adjusting the height of the rectangle based on the percentage.
That would require a macro, or that you do it manually.

 

[AlfD]

Hi!

I suspect that the nearest you will get to that is to use conditiona
format to show different colours for different %age bands. Remember th
3 condition limit.

Al

 

[Debra Dalgleish]

You can do this in an adjacent cell. For example:

1. In cell B4, enter the number 1
2. In cell C4, enter the following formula:
=REPT("x",B4*100)
3. Format cell C4 as Monotype Sorts font, and add a border to the cell.
4. Adjust the width of cell C4 to fit the bar.
5. Now, you can enter a percentage in cell B4 and the bar in
cell C4 will be adjusted.

 

[Myrna Larson]

Hi, Debra:

Nice. When he said fill *up* it took it literally, meaning fill from the
bottom to the top, and I forgot about the ability to rotate the text.

Myrna Larson

 

[Guest]

That's quite elegant! Unfortunately, I don't have Monotype Sorts, but I can
see the effect using other fonts.

 

[Dave Peterson]

or even just:

=REPT("|",B4*100)
in arial.

That's quite elegant! Unfortunately, I don't have Monotype Sorts, but I can
see the effect using other fonts.

 

[Don Guillett]

Nice one