Merging number with unit & condtional formating

[panmuskul]

Hi All,

I have the following issues:

Issue 1: I would like to keep the correct formating in column F when mearging number with the unit like for example 30oC with supperscript

Issue 2: I would like to use conditional formatting in column F. Highlight all that are above 50 and below 30 .

I am attaching the relevant document (please note I am currently living in Poland)

Thanks a lot

[Bo_Ry]

Please try Custom Number format

[Red][>50]0 ᵒC;[Blue][<30]0 ᵒC;0 ᵒC

or
0 ᵒC
and
Conditional formatting
=F3>50

=F3<30

[panmuskul]

That's amazing. Thanks a lot

[panmuskul]

Would you happen to know how to add " m³/hr " so that m³ stays in the superscript ?

Thanks

[Bo_Ry]

https://lingojam.com/SuperscriptGenerator

Custom Number format

0" m³/hr"