Well but how do I incorporate an If statement for marker color? Take following code for example for returning the text "PASS", "FAIL" or "NA" based on entries in column 3:
Sub Example4()
For x = 2 To 7
If Cells(x, 3).Value = "P" Then
Cells(x, 4) = "PASS"
Else
If...