Highlight Cells In Excel For Mac. You can also do this by hiding the rows or columns in your worksheet. Select the range of cells the table or the whole sheet that you want to apply conditional formatting to.
When you select a range of cells the range is highlighted with a colored border and all cells except the active cell are highlighted with a colored fill. Highlight text in Numbers on Mac You can highlight text in text boxes and in shapes. When multiple people are working on a spreadsheet each persons highlights appear in a unique color.
In Excel 2011 Mac it seems to be important since other referenced solutions in stackoverflow for excel windows or mac older versions dont seem to work.
When you select a range of cells the range is highlighted with a colored border and all cells except the active cell are highlighted with a colored fill. Select the range of cells the table or the whole sheet that you want to apply conditional. Examples are dates after this week or numbers between 50 and 100 or the bottom 10 of scores. Extend the selection up one screen.