formula help.. text

M

Murph

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?
 
D

Duke Carey

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
 
Top