Cells B3:E12 of Figure 1 show the quarterly sales for several product lines. Use conditional formatting to call attention to the quarter in each row that had the largest sales compared to the other quarters. You need to build a formula for the top-left corner cell of the range. For cell B3, you want the cell to be highlighted when it's equal to the largest value in B3:E3. In the conditional formatting rule, you could represent this as =B3=MAX($B3:$E3). Note that the reference inside the MAX function is a mix of relative and absolute references. The columns will always be B through E, but the row is allowed to change.
展开▼
