i would like to change background colour of a cell (name) to red in the first
column when a cell along the same row is red. there are 8 columns along the
row not including the name

Look at conditional formatting in help, it will do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cityfc" wrote in message
...
i would like to change background colour of a cell (name) to red in the
first
column when a cell along the same row is red. there are 8 columns along
the
row not including the name