Using wildcard conditional formatting in Excel
I have a column for which I would like the formatting conditional. The column contains the values Actual , Estimate - switch or Estimate - CALC (I have several more of the Estimate -... values makes some). I would like the formatting of the Estimate -... evaluates all to be yellow thus I would like a manner of writing a function for the conditional box of formatting. I thought that it should seem something like follwing:
= Estimate and *
but it is clearly not completely exact. Any help would be appreciated. I would be satified with a LUCKY FIND or IF solution - something which obtains to me with the
|