Forum Discussion
TRS111
Feb 26, 2021Copper Contributor
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...
TRS111
Mar 05, 2021Copper Contributor
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.
PeterBartholomew1
Mar 05, 2021Silver Contributor
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