I'm trying to format a whole row based on the contents of one cell.

Like this...

If D6 or D7, 9, 12, 30, etc. are filled with the letter "R", then I want
that whole row (i.e. 6, 7, 9, 12, 30) to be shaded red.

How can I do this using conditional formatting. I can get the particular
cell to shade red, but not the whole row...based on that one cell.

Thanks!