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!

Select B2:G2.
Click Conditional Formatting and select New Rule.
Select Use formula to determine .....
In the field Format values where this formula is true write: =$B$2<>"".
Click the Format and format as you wish.
OK.