Your goal is to highlight the smallest cell in each row that has a value greater than 0. Your manager wants you to ignore the zero values. But after using this technique, you realize there are quarters where certain products aren’t offered for sale and the zero-quarter sales figures are getting highlighted (see Figure 2). In a similar fashion, you can highlight the smallest value in each row by changing the formula in step 4 to =B3=MIN($B3:$E3). In the case of row 8, where B8 and E8 are equal, both will be formatted. You should see the largest value in each row change color. Click OK to close the New Formatting Rule.Click OK to close the Format Cells dialog.In the Format Cells dialog, click the Fill tab and choose a fill color.Type =B3=MAX($B3:$E3) in the dialog box.In the New Formatting Rule dialog, choose “Use a formula to determine which cells to format.”.Select Home, Conditional Formatting, New Rule.Once you have designed a formula that will work, add the conditional formatting for all the data: The columns will always be B through E, but the row is allowed to change. Note that the reference inside the MAX function is a mix of relative and absolute references. In the conditional formatting rule, you could represent this as =B3=MAX($B3:$E3). For cell B3, you want the cell to be highlighted when it’s equal to the largest value in B3:E3. You need to build a formula for the top-left corner cell of the range. Use conditional formatting to call attention to the quarter in each row that had the largest sales compared to the other quarters.
![conditional formatting excel 2016 how to conditional formatting excel 2016 how to](https://trumpexcel.com/wp-content/uploads/2013/11/Conditional-Formatting-in-Excel-Duplicate.png)
![conditional formatting excel 2016 how to conditional formatting excel 2016 how to](https://i.stack.imgur.com/JQk5v.png)
Cells B3:E12 of Figure 1 show the quarterly sales for several product lines.