View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default 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