Hello, I admit that I'm a VBA dummy. I'm trying to get conditional highlighting into my document and I've read all the posts on the subject, but still couldn't find enough to help with my particular case.

As a workaround, I recorded the following macro in Excel and then tried to paste in to the new editor. The following error appeared "unknown field name: FormatConditions."

Any help would be greatly appreciated! Thanks. - Jen

Sub High()

    Range("H2:AE11").Select

    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
        Formula1:="=$E2", Formula2:="=$F2"

    Selection.FormatConditions(1).Font.ColorIndex = 13

    Selection.FormatConditions(1).Interior.ColorIndex = 18

End Sub