An MS Excel user wants to create a drop-down list against item names and this drop down list should offer only two options: a tick mark tick-mark or a cross cross . We have used Excel VBA or a macro to be able to display both the characters in a drop-down list. The VBA code or macro code is given below:
Sub usingSymbols()
Range(“B2:B6”).Select
With Selection.Font
.Name = “Wingdings 2″
.Size = 12
End With
With Selection.Validation
.Add Type:=xlValidateList, Formula1:=”P,S”
End With
Range(“B2”).Select
End Sub
Watch the video below to understand how we can use symbols in a drop-down list on an Excel worksheet quickly and easily:
Great video, got this to work perfectly but I now have a question. I have set this code across columns J to AN.
What I now want to do is if there is a a tick “P” in the same row but in column J, K, L or M then then cell in one of the rows N to AN turns a colour dependant on formatting.
Do you know how to do this?