Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use a conditional function to insert an autoshape?
I want to set up a function in Excel where if the value is 1, one auto shape
(an empty ball) is inserted and if a value is 2, then another shape (a shaded ball) is inserted. Any ideas? I'm also looking for help in making the shapes (or finding a font to use) that would need to be inserted. I believe they are called rollerballs and I need an empty, a full, a half, a quarter, and a three-quarter full ball. Thanks, |
#2
|
|||
|
|||
J.E. McGimpsey has a routine that does this with pictures.
Maybe you could modify it to do what you want: http://www.mcgimpsey.com/excel/lookuppics.html ToledoMichael wrote: I want to set up a function in Excel where if the value is 1, one auto shape (an empty ball) is inserted and if a value is 2, then another shape (a shaded ball) is inserted. Any ideas? I'm also looking for help in making the shapes (or finding a font to use) that would need to be inserted. I believe they are called rollerballs and I need an empty, a full, a half, a quarter, and a three-quarter full ball. Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert row within function | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
insert picture | Excel Discussion (Misc queries) | |||
How do I insert a row when using an if function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |