When cell B2 contains data, I need to have cells B2:G2 (a table row) highlighted yellow. I found the built in rule to highlight a cell when it isn't blank, but it doesn't extend across multiple cells. It also doesn't give me a way to reference Column B as being the cell that determines the formatting, if I try to apply that rule in the other columns.



What is the formula for this?

Thanks!