Can I show a percent as a fill color

K

karmal

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.
 
M

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.
 
A

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
 
D

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.
 
M

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
 
A

Allan S. Warrior

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

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.
Click to expand...
 
Top