fill cell based on percentage

[enri]

I want to show graphically percentage values contained
in some cells.
Is it possible to fill the cell with a color up to the percentage
value?
I now use square symbols but I want to improve the result,
and I prefer not use a graph.
Thank yo

 

[Andy Pope]

Hi,

I assume you are using an approach similar to the one described here,
http://j-walk.com/ss/excel/usertips/tip052.htm

If so you can use the Full block character (? Unicode &H2588 Arial font)
to create a solid bar.

Cheers
Andy

 

[enri]

Great! that was what I was looking for!
But now I want more: to change colour, also! I tried to add in
the formula from the example something like TEXT(...,"@[red]")
but it seems that colours do not work, so maybe I will use
conditional formatting.
Thanks
Enrico

By the way, how can I put the exact unicode you mentioned?
I had to use Word "insert symbol" and look at the pictures...

 

[Andy Pope]

Hi Enrico,

You can either change the font colour or, as you say, conditional
formatting if you want it to be more dynamic.

I use the windows CharacterMap program to see and copy in obscure
characters.
You could also write your own function to do it. The code for the Full
block is 9608. So in the cell you would have something like,

=REPT(charw(9608),10)

' place in a code module
Public Function CharW(CharCode As Long) As String
CharW = ChrW(CharCode)
End Function

Cheers
Andy

Great! that was what I was looking for!
But now I want more: to change colour, also! I tried to add in
the formula from the example something like TEXT(...,"@[red]")
but it seems that colours do not work, so maybe I will use
conditional formatting.
Thanks
Enrico

By the way, how can I put the exact unicode you mentioned?
I had to use Word "insert symbol" and look at the pictures...

*Hi,

I assume you are using an approach similar to the one described
here,
http://j-walk.com/ss/excel/usertips/tip052.htm

If so you can use the Full block character (? Unicode &H2588 Arial
font)
to create a solid bar.

Cheers
Andy
*