Forum Discussion
Insert Degree Symbol in Average Calculation
I have a list of temperatures that is 364 rows long and have an average calculation at the bottom. I am attempting to find a way to enter, if possible, the degree symbol ASCII 0176 in the line of te...
I agree with Riny_van_Eekelen
Number formatting is the correct way of addressing your problem since it leaves the cell value unchanged but displays it in any manner you require. It is unusual to change the number formatting within a conditional format but it is quite possible.
What you should try to avoid is inserting spurious characters into a number because calculation then becomes arduous.
Thank you for your answer. The cinditional formatting came about to indicate temps above or below certain numbers so heat (in Texas) and cold +/- certain temps would color code the long column I shall try a rework.
The image is nothing more than number formatting. White text on a black background with smaller numbers in Cyan and larger values in red.
[Cyan][<40]0°F;[Red][>80]0°F;0°F