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
|