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