Excel conditional formatting using a wildcard

[OceanDesigner]

I have a column for which I would like conditional formatting. The column contains the values "Actual", "Estimate - SW" or "Estimate - Calc" (in fact I have several more of the "Estimate - ..." values). I would like the formatting of the "Estimate - ..." values all to be yellow so I would like a way to write a function for the conditional formatting box. I was thinking it should look something like the follwing:

="Estimate" & *

but that is clearly not quite right. Any help would be appreciated. I would be satified with a FIND or IF solution - anything that gets me to the formatting I am looking for.

Thanks,
Jeff

 

[AnotherHiggins]

Make sure to change from Value Is to Formula Is, then put this in:
[tab]=IsNumber(Search("estimate",$A1))

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[OceanDesigner]

Oh, I get it. Thanks.