I need to produce some VBA for a Formula Conditional Formatting. The
spreadsheet I need use the VBA on is overlaid by ACCESS, so using the
traditional conditional formatting will not work. I can however get the
desired results using the dropdown Conditional Formatting, choosing Formula
Is and entering =RIGHT($E39,5)="Total" and Bold/Italic.

I'm very new to VBA, and my latest attempt is:

Range("E1:K61000").Select
Selection.FormatConditions.Add Type:=xlExpression, _
Formula1:="=RIGHT($E1,5)='Total'"
Selection.FormatConditions(1).Bold = True
Selection.FormatConditions(1).Italic = True

Run time is rejecting the second & third lines. Any suggestions?

Thank you,
Cathy