Meaningful way to easily (not mysteriously) change colors in my macro?

[Gingertrees]

In my macro, I utilize conditional formatting to create alternating rows of color. The powers that be have tired of the sage green I've been using. How do I easily change the color in the following piece of code? Say I want to change it to pink, and then later on I change my mind and want to set it to light blue.

I know I could just take a stab at changing numbers - but is there a better way? Maybe set these to HEX colors?

Cells.Select    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=MOD(ROW(),2)=1"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent6
        .TintAndShade = 0.599963377788629

 

[shg]

Maybe

    With Cells.FormatConditions
        .Delete
        .Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)"
        .Item(1).SetFirstPriority
        With .FormatConditions(1).Interior
            .Color = RGB(255, 225, 225)

That's an awful lot of formatting to add, though.

 

[Gingertrees]

"Awful lot of formatting" - How do you mean?

 

[shg]

You're adding conditional formatting to every cell on the sheet.

The code had a mistake:

    With Cells.FormatConditions
        .Delete
        .Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=1"
        With .Item(1)
            .SetFirstPriority
            .Interior.Color = RGB(255, 225, 225)
        End With
    End With

 

[Gingertrees]

Oh. That might explain why it takes so long to run.
This is pretty much just what the macro recorder transcribed. How would I tell it "for used range, apply this conditional formatting"?

 

[shg]

  Cells.FormatConditions.Delete
  
  With ActiveSheet.UsedRange.FormatConditions
        .Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=1"
        With .Item(1)
            .SetFirstPriority
            .Interior.Color = RGB(255, 225, 225)
        End With
    End With

 

[Gingertrees]

OK, thanks. There's a bunch of RGB color charts available online, so that helps me greatly

 

[shg]

You're welcome, good luck.

You could also use the color selection tool for cell interior and font color formatting.