CELL COLORING BY % Percentage

  • Thread starter Thread starter ExcelUser777
  • Start date Start date
E

ExcelUser777

HI

basically i'd like to only show coloring in part of a cell
so for example
cell A1 is grey only 33% of the cell is grey



I'd like to color one cell grey 33%

I have several cells to color, different percentages...
once i see one macro i can create the other percentages...


Is that possible with a macro?

appreciate all your help

Excel 2003 preferably

Thanks,
ExcelUser777
 
that's built into excel 2007

--

Gary K













- Show quoted text -
Click to expand...

thanks..Gary...this can be done in Excel 2003 as well..i've seen a
post but the post on google groups didn't work....but that is good to
know...
 
A different approach...
If you have room/inclination for a helper column then you can use a
formula similar to this in the helper column and fill down...
=IF(A2>0,REPT("n",ROUND(A2*100,0)),"")
The formula can be in any column. Set the font to Wingdings and the font
color to something distinctive.
The above assumes that the values in column A are percentages.
It the values are whole numbers the formula may have to be adjusted.
--
Jim Cone
Portland, Oregon USA


"ExcelUser777"
<[email protected]>
wrote in message
HI
basically i'd like to only show coloring in part of a cell
so for example
cell A1 is grey only 33% of the cell is grey
I'd like to color one cell grey 33%
I have several cells to color, different percentages...
once i see one macro i can create the other percentages...
Is that possible with a macro?
appreciate all your help
Excel 2003 preferably
Thanks,
ExcelUser777
 
A different approach...
If you have room/inclination for a helper column then you can use a
formula similar to this in the helper column and fill down...
   =IF(A2>0,REPT("n",ROUND(A2*100,0)),"")
The formula can be in any column. Set the font to Wingdings and the font
color to something distinctive.
The above assumes that the values in column A are percentages.
It the values are whole numbers the formula may have to be adjusted.
--
Jim Cone
Portland, Oregon  USA

"ExcelUser777"
<[email protected]>
wrote in message
HI
basically i'd like to only show coloring in part of a cell
so for example
cell A1 is grey only 33% of the cell is grey
I'd like to color one cell grey 33%
I have several cells to color, different percentages...
once i see one macro i can create the other percentages...
Is that possible with a macro?
appreciate all your help
Excel 2003 preferably
Thanks,
ExcelUser777
Click to expand...

Hi
Jim I tried this, but the nnnn's cross cells...I would only want to
shade one cell at a time.... 33% of one cell 34% of the next cell and
33% of the next cell
wing dings turns them into dark square boxes..




Thanks
 
Hi

You could use your normal font and use the pipe character "|" rather than
"n" as in Jim's formula.
You will need to widen your columns to cope with the largest value in your
source column, so that there is no overlap into the cell to the right.
You can scale the data to make it take less space
=IF(A2>0,REPT("|",ROUND(A2*10,0)),"")
but of course you will loose granularity and will not distinguish between 30
and 39, both will appear as 4 vertical pipes.
 
Back
Top