Conditional Formatting - How To Get It To Check To See If The Celll Contains A Certain Charachter?

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

Greeting,

I am trying to get a cell to show a color if a "+" sign is anywhere
within the cell (these cell contain only text). I tried conditional
formatting, but it only seems to allow for cell value is "equal to" or
"formula".

Any ideas?

TIA

-Minitman
 
Minitman,

If your cell is A1 , select the formulaoption of the conditional formatting
and use in the formulabox :

=NOT(ISERROR(FIND("+",A1,1))).

(Conditional) Format the cell as you want.

( NB : If you use the european setting, replace the , in the formula with
; )

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Use CF:

Formula Is =COUNTIF(A1,"*+*")

the CF will be applied if the formula evaluates to TRUE.
 
Back
Top