formula help.. text

[Guest]

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?

 

[Guest]

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

 

[Guest]

don't i need to define the formula with "istext" or something of that nature?

 

[Guest]

don't i need a formula such as "istext" or something?

 

[Guest]

Nope - just as stated in my original response

don't i need a formula such as "istext" or something?