>>>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

Thanks, I think I can use SEARCH, but so far I decided to use UPPER and LEFT for simplicity. Thanks again.