Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula help.. text
I am trying to get a series of cells to fill with a color if the word
"insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed in so up to A5 will change color. How do I go about doing this? |
#2
|
|||
|
|||
Try Format | Conditional Formatting - after selecting cells A2:a5
Then use "Formula is" and type in =$A2 = "insert" Then click on the Format button and select the color you want from the Patterns tab "Murph" wrote: I am trying to get a series of cells to fill with a color if the word "insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed in so up to A5 will change color. How do I go about doing this? |
#3
|
|||
|
|||
don't i need to define the formula with "istext" or something of that nature?
"Duke Carey" wrote: Try Format | Conditional Formatting - after selecting cells A2:a5 Then use "Formula is" and type in =$A2 = "insert" Then click on the Format button and select the color you want from the Patterns tab "Murph" wrote: I am trying to get a series of cells to fill with a color if the word "insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed in so up to A5 will change color. How do I go about doing this? |
#4
|
|||
|
|||
don't i need a formula such as "istext" or something?
"Duke Carey" wrote: Try Format | Conditional Formatting - after selecting cells A2:a5 Then use "Formula is" and type in =$A2 = "insert" Then click on the Format button and select the color you want from the Patterns tab "Murph" wrote: I am trying to get a series of cells to fill with a color if the word "insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed in so up to A5 will change color. How do I go about doing this? |
#5
|
|||
|
|||
Nope - just as stated in my original response
"Murph" wrote: don't i need a formula such as "istext" or something? "Duke Carey" wrote: Try Format | Conditional Formatting - after selecting cells A2:a5 Then use "Formula is" and type in =$A2 = "insert" Then click on the Format button and select the color you want from the Patterns tab "Murph" wrote: I am trying to get a series of cells to fill with a color if the word "insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed in so up to A5 will change color. How do I go about doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coverting Formula to Text | Excel Discussion (Misc queries) | |||
Text in Cell as Formula | Excel Discussion (Misc queries) | |||
merging text without using a formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |