excel_stuff
Member
Dear Experts,
I am using a slider to change values in a particular cell. Now depending on the value in the cell I would like to show shapes next to it (in a text box or cell or whatever). So for example if cell value is 10, I want to show a 5 green triangles, when its 8 then 4 triangles etc.
If the above could be done then I would like to make it more complicated but reducing the size of the fifth triangle as we move below 10, until we reach 8 when the fifth triangle disappears. Then the same happens to the fourth triangle as we go below 8, and so forth.
Then I want to do the same for a different scenario but using squares.
I would really appreciate your help with this!
Thanks
ExcelStuff
I am using a slider to change values in a particular cell. Now depending on the value in the cell I would like to show shapes next to it (in a text box or cell or whatever). So for example if cell value is 10, I want to show a 5 green triangles, when its 8 then 4 triangles etc.
If the above could be done then I would like to make it more complicated but reducing the size of the fifth triangle as we move below 10, until we reach 8 when the fifth triangle disappears. Then the same happens to the fourth triangle as we go below 8, and so forth.
Then I want to do the same for a different scenario but using squares.
I would really appreciate your help with this!
Thanks
ExcelStuff