VBA Conditional Formatting - Change Font Color across row per 1st column (6 colors)

And trying to figure out how to set up a macro to on opening ... thought I had it, but I get a "Compile Error: Named argument not found" on the

Private Sub Workbook_Open()

line