>>Sample:
>>

>>  .FormatConditions.Delete
>>  .FormatConditions.Add(xlExpression,, '=Left($D2,5)="Sales"')
>>  With .FormatConditions(1)
>>    .Font.Bold = .T.
>>    .Interior.ColorIndex = 4
>>  Endwith
>>

Cetin
>
>What is the first WITH here? E.g. FormatConditions is the property of what?

sheet

PS: Are you trying to automate Excel w/o documentation?
Cetin