Today I finaly set up a #VBAMacro in #Excel to add conditional formatting to set cells =0 as light grey.
Small thing, but I find it helpful.
Save this in Personal.xlsb, add a Quick Access shortcut
Sub GreyZero()
' GreyZero Macro
' Format selected cells with contitional formatting to set zero values to light grey
'
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=0"
With Selection.FormatConditions(1).Font
.Color = -1381654
End With
End Sub