Hi all,

How to do the conditional formatting if I want in A3:P200 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




--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
102 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!