I want to change the background of a whole line in a
worksheet every where where the value of a cell in that
line is X. =indirect("rc",0)= "x" only changes the
background in the cell not the whole line