Option Explicit
Private Sub Worksheet_SelectionChange(ByVal c As Range)
Dim plage As Range
Set plage = Range("c7:c100") ' à adapter
If c.Column <> 3 Then Exit Sub
For Each c In plage
If c = "" Then c = " °C" Else c.NumberFormat = "#"" °C"""
Next
End Sub