Conditional Formatting - find cells containg "+"

[Colin Hayes]

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

 

[John]

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

 

[Colin Hayes]

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/showthread.php?s=87cf23dcb753db2af180d26b9ea58504&t=109806



Both of these work well.


Best Wishes


Colin

 

[John]

Hi Colin
You're welcome, glad you solved your problem.
Thanks for your feedback.
regards
John