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