Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color Filling a Cell BZBOYLE Excel Discussion (Misc queries) 4 February 11th 09 09:57 PM
What is the shortcut key to filling color in the format tool bar. mabola2 Excel Discussion (Misc queries) 1 October 21st 07 03:54 PM
filling color Marcelo Hofmeister Antoniazzi Excel Discussion (Misc queries) 2 July 24th 07 08:27 PM
Filling cell with color using barcode scanner lg Excel Discussion (Misc queries) 1 November 24th 05 12:57 AM
Sum cells based on a row variable and seperate column variable CheeseHeadTransplant Excel Worksheet Functions 10 September 23rd 05 06:59 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"