Conditional Formatting - find cells containg "+"

C

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
 
J

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
 
C

Colin Hayes

John said:
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
 
J

John

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top