You are right, it is not worth the effort...

Recording a macro to highlight for the first time is easy... you run into
issues when you want to remove highlighting when constant changes to a
formula or vice versa.
One option is to write this into WorkSheet_Change macro like the one below

Private Sub Worksheet_Change(ByVal Target As Range)

Target.SpecialCells(xlCellTypeConstants, 23).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
End With
End Sub

"Julian Bessenroth" wrote:

On 11 Okt., 01:41, Sheeloo wrote:
Then you need to use VBA. Let me know if you need help with that.

Thanks Sheeloo,

if it is like this then I think I'll go for the first method.
Otherwise it'd be somewhat too sophisticated/overkill for what I
intend to do.

Thanks anyway.

Regards

Julian