Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Range("Z2:Z" & LastRow).Select
- Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
- Formula1:="=""NEW EMPLOYEE"""
- Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
- With Selection.FormatConditions(1).Interior
- .PatternColorIndex = xlAutomatic
- .Color = 13408767
- .TintAndShade = 0
- End With
Add Comment
Please, Sign In to add comment