AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() 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. Cells B3:E12 of Figure 1 show the quarterly sales for several product lines.
0 Comments
Read More
Leave a Reply. |