Conditional Formatting - find cells containg "+"
 

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

Conditional Formatting - find cells containg "+"
 

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" 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

Conditional Formatting - find cells containg "+"
 

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

Conditional Formatting - find cells containg "+"
 

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