Hello Friends,
Please Like, Comment, Share and Subscribe to my Channel.
Please Subscribe ......
Lot's of love .... ❤️❤️❤️
Thank you ...
Conditional Formatting :
When you click the Conditional Formatting button in the Styles group of the Home tab, a drop-down menu appears with the following options:
Highlight Cells Rules opens a continuation menu with various options for defining formatting rules that highlight the cells in the cell selection that contain certain values, text, or dates; that have values greater or less than a particular value; or that fall within a certain ranges of values.
Top/Bottom Rules opens a continuation menu with various options for defining formatting rules that highlight the top and bottom values, percentages, and above and below average values in the cell selection.
Data Bars opens a palette with different color data bars that you can apply to the cell selection to indicate their values relative to each other by clicking the data bar thumbnail.
Color Scales opens a palette with different two- and three-colored scales that you can apply to the cell selection to indicate their values relative to each other by clicking the color scale thumbnail.
Icon Sets opens a palette with different sets of icons that you can apply to the cell selection to indicate their values relative to each other by clicking the icon set.
New Rule opens the New Formatting Rule dialog box where you define a custom conditional formatting rule to apply to the cell selection.
Clear Rules opens a continuation menu where you can remove conditional formatting rules for the cell selection by clicking the Clear Rules from Selected Cells option, for the entire worksheet by clicking the Clear Rules from Entire Sheet option, or for just the current data table by clicking the Clear Rules from This Table option. If you’re working with a Pivot Table, you can clear the conditional formatting from it by clicking the Clear Rules from This PivotTable option at the very bottom of this menu.
Manage Rules opens the Conditional Formatting Rules Manager dialog box where you edit and delete particular rules as well as adjust their rule precedence by moving them up or down in the Rules list box.
Data Bars represent the relative values in the cell selection by the length of the color bar in each cell and are great for helping you quickly spot the lower and higher values within a large range of data.
Color Scales classify the relative values in a cell selection with a color gradation using a one-, two-, or three-color scale and are great for identifying the distribution of values across a large range of data.
Icon Sets classify the values in the cell selection into particular graphic sets arranged in four categories, and each icon within a set represents a range of values that go from high to low. Icon sets are great for quickly identifying the different ranges of values in a range of data.
Негізгі бет Excel - Condition Formatting - Manage Rules, Edit Rule, Complete Excel Training Pack and Many More
Пікірлер: 8