ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Filling in color in a box based upon a variable . (https://www.excelbanter.com/excel-worksheet-functions/170636-filling-color-box-based-upon-variable.html)

Dan C

Filling in color in a box based upon a variable .
 
I would like to fill a shape (box) with a colour based upon a specific
number. For example, if a number is .25 then I would like to show the box 25%
full by having the bottom 25% filled with a colour. The colour would fill
more or less of the box based upon a variable entry. I would like to use a
slider tool to select this amount. Can anyone help with how to do this?

Max

Filling in color in a box based upon a variable .
 
Perhaps this post by Myrna Larson would be relevant:
http://tinyurl.com/38pd75
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dan C" wrote:
I would like to fill a shape (box) with a colour based upon a specific
number. For example, if a number is .25 then I would like to show the box 25%
full by having the bottom 25% filled with a colour. The colour would fill
more or less of the box based upon a variable entry. I would like to use a
slider tool to select this amount. Can anyone help with how to do this?



All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com