The relationship of values in a cell range. Point to Highlight Cells Rules or Top/Bottom Rules, and then click the appropriate option. Examples are dates after this week, or numbers between 50 and 100, or the bottom 10% of scores. On the Home tab, click Conditional Formatting. Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. The following example shows temperature information with conditional formatting applied to the top 20% and bottom 20% values:Īnd here's an example with 3-color scale conditional formatting applied: Or you can format a whole cell range and vary the exact format as the value of each cell varies. You can use conditional formatting to highlight cells that contain values which meet a certain condition. This changes the appearance of a cell range based on a condition (or criteria). LessĬonditional formatting makes it easy to highlight certain values or make particular cells easy to identify. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac More.
0 Comments
Leave a Reply. |