change background colour

C

cityfc

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
 
B

Bob Phillips

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

--

HTH

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