Excel in telugu about Styels Group Part 4

Excel in telugu

To apply several formats in one step, and to make sure that cells have consistent formatting, you can use a cell style. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.

Applying Cell Highlighting

You can apply highlighting to cells if they satisfy criteria that you set. The criteria can be number-based (e.g., greater than, less than, equal to), text-based (e.g., text contains, date occurring), or both (e.g., duplicate values).

1. Select the range of cells to be formatted
2. From the Home command tab, in the Styles group, click CONDITIONAL FORMATTING
   A pull-down list appears.
3. Select Highlight Cells Rules » select the desired criterion
   A dialog box appears.
4. In the dialog box, specify your criteria
   NOTE: The criteria will differ depending on the option chosen in step 3.
5. Click OK
   The rule is applied to cells which satisfy the criteria.Applying Top, Bottom, and Average Rules

   You can apply conditional formatting to cells that satisfy criteria based on on the ten highest or lowest numbers, percentages, or averages.

   1. Select the range of cells to be formatted
   2. From the Home command tab, in the Styles group, click CONDITIONAL FORMATTING
      A pull-down list appears.
   3. Select Top/Bottom Rules » select the desired criterion
      A dialog box appears.
   4. In the dialog box, specify your criteria
      NOTE: The criteria will differ depending on the option chosen in step 3.
   5. Click OK
      The rule is applied to cells which satisfy the criteria.Applying Data Bars, Color Scales, and Icon Sets

      Data Bars, Color Scales, and Icon Sets will format all cells in a range, depending on how each cell compares to the rest of the range.

      EXAMPLES: In the following graphic, each column represents a preformatted rule as the value increases.

      Data Bars	Color Scales	Icon Sets

      1. Select the range of cells to be formatted
      2. From the Home command tab, in the Styles g
   6. A pull-down list appears.
   7. Select Data Bars, Color Scales, or Icon Sets » select your desired style
      The rule is applied.