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