conditional formatting with asterisk

[Jack Sons]

Hi all,

How to do the conditional formatting if I want in A3200 the back ground
color of a cell to be yellow if it contains an asterisk. Example, cells may
look
like ABC/D*EF/JSO/HIJ in which case I want the back ground yellow.
I tried a lot, but (for instance) =countif($A$3="~*" ) etc. won't work. How
to make clear that with
* is meant just that character, not the wildcard?

TIA

Jack Sons
The Netherlands

 

[Alan]

Try
=ISNUMBER(FIND("*",A3))
Regards,
Alan.

 

[Guest]

Put this conditional format in A3 after selecting Formula is

=FIND("*",A3)>0

Then use the format painter to paint the format into your range of cells.

Mike

 

[Dave Peterson]

How about:

=ISNUMBER(SEARCH("~*",$A$3))

You really want those $'s?

 

[Dave Peterson]

And you don't even need the =isnumber() bit.

=SEARCH("~*",$A$3)

An error will be treated as false.

 

[Guest]

=COUNTIF($a$3,"*~**")

You have to account for the characters before and after

 

[Jack Sons]

Gentlemen,

Thanks for your help (fast as lightning) and the explanation.

Jack.