![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |