I have the following code
Private Sub Worksheet_Change(ByVal Target as Range) Target.Font.ColorIndex = 5 End Sub
I want to make this code work in the worksheet, but it won't save as a macro or run because the module only accepts the
Sub () End Sub syntax. What do I do?