how do automatically change entire row color when cell changes

I

IOE

Hi,
is it possible to change the color of the row cell1 is in when cell1 changes
to a specified text?
 
F

Frank Kabel

Hi
- select the row (e.g. row 1)
- goto 'Format - Conditional Format'
- enter the following formula
=$A1="Text"
- choose your format
 
Top