![]() Note: you can also use this category (see step 3) to highlight the top n items, the top n percent, the bottom n items, the bottom n percent or cells that are below average. Excel calculates the average (42.5) and formats the cells that are above this average. To highlight cells that are above average, execute the following steps.ģ. Click Clear Rules, Clear Rules from Selected Cells. To clear a conditional formatting rule, execute the following steps.ģ. Note: you can also use this category (see step 3) to highlight cells that are less than a value, between two values, equal to a value, cells that contain specific text, dates (today, last week, next month, etc.), duplicates or unique values. Excel changes the format of cell A1 automatically. ![]() Excel highlights the cells that are greater than 80. ![]() Enter the value 80 and select a formatting style. Click Highlight Cells Rules, Greater Than.Ĥ. On the Home tab, in the Styles group, click Conditional Formatting.ģ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |