Then click on the Conditional Formatting drop-down and select Manage Rules from the popup menu. Select the Home tab in the toolbar at the top of the screen.
In this example, we've selected cells A1 through A5.
Question: In Microsoft Excel 2011 for Mac, is there a way to shade one cell green if it is the highest value in a range of cells, and to shade another cell red if it is the lowest number in a range of cells?Īnswer: Yes, you can use conditional formatting to highlight the highest and lowest values in a range of cells.įirst highlight the range of cells.
