| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condiitonal formatting-colored cell
I would like a cell to turn yellow if I start a sentence with an *, if there
is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
Use formula is
=ISNUMBER(SEARCH("if there is no",A2)) in the example you would change the appearance of A2 I assume you know how to select the format in the pattern tab -- Regards, Peo Sjoblom "Diane" wrote in message ... I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
Sorry, but I am not understanding your formula.
All I want to do is go in the Format/conditional formatting, and findout what formula I should put in there to: I have a row (merged cells) where I need to write text. I want the row to turn yellow if I start the text with an asterix*. If there is no asterix*, then it can stay no fill. Thanks. "Peo Sjoblom" wrote: Use formula is =ISNUMBER(SEARCH("if there is no",A2)) in the example you would change the appearance of A2 I assume you know how to select the format in the pattern tab -- Regards, Peo Sjoblom "Diane" wrote in message ... I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
With example in A7
=LEFT(A7,1)="*" if you leave the $ that it puts by default it will mess you up. -- -John Please rate when your question is answered to help us and others know what is helpful. "Diane" wrote: I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
What I put there is exactly what you are going to put there after you select
formula is then click the format button and select a yellow pattern. Replace A2 in the formula with the cell you want to use -- Regards, Peo Sjoblom "Diane" wrote in message ... Sorry, but I am not understanding your formula. All I want to do is go in the Format/conditional formatting, and findout what formula I should put in there to: I have a row (merged cells) where I need to write text. I want the row to turn yellow if I start the text with an asterix*. If there is no asterix*, then it can stay no fill. Thanks. "Peo Sjoblom" wrote: Use formula is =ISNUMBER(SEARCH("if there is no",A2)) in the example you would change the appearance of A2 I assume you know how to select the format in the pattern tab -- Regards, Peo Sjoblom "Diane" wrote in message ... I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
Sorry, I misunderstood. I thought you were looking to find the words
"if there is no" Use =TRIM(LEFT(A2))="*" -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... What I put there is exactly what you are going to put there after you select formula is then click the format button and select a yellow pattern. Replace A2 in the formula with the cell you want to use -- Regards, Peo Sjoblom "Diane" wrote in message ... Sorry, but I am not understanding your formula. All I want to do is go in the Format/conditional formatting, and findout what formula I should put in there to: I have a row (merged cells) where I need to write text. I want the row to turn yellow if I start the text with an asterix*. If there is no asterix*, then it can stay no fill. Thanks. "Peo Sjoblom" wrote: Use formula is =ISNUMBER(SEARCH("if there is no",A2)) in the example you would change the appearance of A2 I assume you know how to select the format in the pattern tab -- Regards, Peo Sjoblom "Diane" wrote in message ... I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condiitonal formatting-colored cell
Thanks works perfectly!
"John Bundy" wrote: With example in A7 =LEFT(A7,1)="*" if you leave the $ that it puts by default it will mess you up. -- -John Please rate when your question is answered to help us and others know what is helpful. "Diane" wrote: I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting: colored bar with pointer on current status | Excel Discussion (Misc queries) | |||
| how to filter through a colored cell which has no value??? | Excel Discussion (Misc queries) | |||
| filter by colored cell? | Excel Worksheet Functions | |||
| SUMIF cell is colored | Excel Discussion (Misc queries) | |||
| get a colored text in one cell to appear the same way in others | Excel Discussion (Misc queries) | |||
Linear Mode
