Hi all
I recorded a simple macro to identify any blank cells, conditional format these in red
Sub Blank_higlighter()
'
' Blank_higlighter Macro
'
'
Columns("A:P").Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=LEN(TRIM(A1))=0"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
End Sub
My question is I I saved these in my personal workbook.. but I want to share these with multiple colleagues
what/how should i share it? they will need to use the code on multiple workbooks?
Thanks
Bookmarks