>>>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.
If it's not broken, fix it until it is.
My Blog