Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
Conditional formatting cells with formulas = "#VALUE!" | Excel Discussion (Misc queries) | |||
Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) |