The following snippet of code is supposed to change the value in the
8th column row the row MatchLineNum to "Yes" and then change the first
22 columns of that row to black font.

With Sheets("Macquarie Commissions")
..Cells(MatchLineNum, 8).Value = "Yes"
..Cells(MatchLineNum, 22).Font.ThemeColor = xlThemeColorLight1
End With

The "Yes" part works fine.
The font colour change on the other hand doesn't do anything at all.
The font colour remains the same as it was before the macro was run.

Why?

Travis