Hi

Try this formula:

=IF(ISERROR(SEARCH("s",A2;1)),,1)0

Regards,
Per

"JohnPM" skrev i meddelelsen
...
I use three conditions in the active cell. Entry "A" returns yellow
background, Entry "O" returns green and entry "S" returns red. I would
like
to get a RED return in all cases "S" is used in the active cell as in S1
or
S2 or S3 or S4 etc. Wildcard is apparently not an option in CF. Any neat
solutions?