P
Phil Hageman
In cell H29 is a function-created (average) percentage number, say 94%.
In cell J2 is a manully inputted upper threshold percent number, say 98%
In cell J4 is a manully inputted lower threshold percent number, say 92%
Color protocol:
<=J4 is Red
In this example, the required color is Yellow (94% is between 98% and 92%).
I have to create a graphic of a thermometer showing the color, the percentage (cell H29), and have the thermometer depict a line representing the 94%.
Does anyone know how to create such a graphic, or is there a template somewhere? The graphic is to be located in an Excel worksheet and must respond automatically to changes in the cells.
Thanks,
Phil
In cell J2 is a manully inputted upper threshold percent number, say 98%
In cell J4 is a manully inputted lower threshold percent number, say 92%
Color protocol:
between J2 and J4 is Yellow
<=J4 is Red
In this example, the required color is Yellow (94% is between 98% and 92%).
I have to create a graphic of a thermometer showing the color, the percentage (cell H29), and have the thermometer depict a line representing the 94%.
Does anyone know how to create such a graphic, or is there a template somewhere? The graphic is to be located in an Excel worksheet and must respond automatically to changes in the cells.
Thanks,
Phil