>>Sample:
>>

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

Cetin
>
>Cetin,
>
>Thanks again. I tried to applied the conditional formatting interactively:
>
>="search(""Total"",$A$191) > 0", but nothing changed. I'm not sure how to specify formula that I want to apply formatting if I have some specific text in the first column and apply this formatting for that row.

Read the sample.
Cetin