Advertisement · 728 × 90
#
Hashtag
#VBAMacro
Advertisement · 728 × 90
Original post on mastodon.scot

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 […]

1 0 0 0