Hi Colin
You're welcome, glad you solved your problem.
Thanks for your feedback.
regards
John
"Colin Hayes" wrote in message
...
In article , John
writes
Hi Colin
if the Plus sign + is part of a text string Select the column range first
then
=FIND("+",A2:$A$160) change the range to your needs.
If the + sign is alone in the cell, you don't need a formula, just select
Cell
value is then select Equal to and type the plus sign in the third box.
HTH
John
Hi John
OK thanks for getting back. Very kind of you.
Since I posted I've dug around and found solutions here too :
http://j-walk.com/ss/excel/usertips/tip045.htm
Http://www.excelbanter.com/showthrea...504& t=109806
Both of these work well.
Best Wishes
Colin
"Colin Hayes" wrote in message
...
Hi
I need some help with conditional formatting.
I'm trying to highlight those cells which have a plus sign in them. Can
someone help with the formula to enter into the conditional formatting
dialogue?
Grateful for any assistance.
Best Wishes