How can I fill a cell with "+" based on a percent value?

D

Dreiding

I have Excel 2003 and need the capability to fill cells with a character
symbol (+) based on a value (0-100). Where as 50% would only fill have the
cell, 100% the complete cell.

The issues I'm running into are related to the column width (what happens
when the user changes the column width) and the zoom factor. Not sure if the
monitor resolution has an impact. I've found that a zoom of 75 has a much
different impact than one of 50 or 80.

Thanks,
- Pat
 
D

Dreiding

Almost there! I really like your equation.
I set my Excel font default to Arial 8.
Unfortunately it's not immune to zoom.
Set the percent value to 100% and see how it fills the cell at different
zooms (75 vs 80). Is there info on what Excel does so I can adjust to it?

Thanks for you quick response!
- Pat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill color based on RGB 12
Fill cell based on cell value 7
Random selection of records based on specifc value 5
Select value on a cell by matching value of two cells 1
Can RGB fill color be automated based on 3 cell values? 2
How do I fill a Cell with a symbol 1
hide multiple worksheets based on a formula value in one cell 1
VBA help w/ look & fill in data 20

Top