Скачать или смотреть How to Use Icon Sets in Excel in Tamil | Conditional Formatting in Excel in Tamil

Excel icon sets
How to Use Icon Sets in Excel in Tamil | Conditional Formatting in Excel in Tamil

In this Video we will learn about, Icon Sets in Excel are ready-to-use formatting options that add various icons to cells, such as arrows, shapes, check marks, flags, rating starts, etc. to visually show how cell values in a range are compared to each other.

How to use icon sets in Excel
To apply an icon set to your data, this is what you need to do:

Select the range of cells you want to format.
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Icon Sets, and then click the icon type you want.
That's it! The icons will appear inside the selected cells straight away.

How to Use Color Scales in Excel in Tamil | Excel Conditional Formatting in Tamil

In this video we will learn about Format cells by using color scales...

To add a color scale, execute the following steps.

1. Select the range.
2. On the Home tab, in the Styles group, click Conditional Formatting.
3. Point to Color Scales, and then click the color scale format that you want. The top color represents larger values, the center color represents middle values, and the bottom color represents smaller values.

If you want customize this color scale.

1. Select the range.
2. On the Home tab, in the Styles group, click Conditional Formatting, Manage Rules.
3. Click Edit rule.

Excel launches the Edit Formatting Rule dialog box. Here you can further customize your color scale (Format Style, Minimum, Midpoint and Maximum, Color, etc).

----------------------------------------------------------------------------------------
Related Videos:

Excel Conditional Formatting in Tamil | Highlight Cell Values in Excel in Tamil -    • Excel Conditional Formatting in Tamil | Hi...  

How to Top/Bottom Rules conditional formatting in excel in tamil -    • How to Use Top/Bottom Rules Conditional Fo...  

How to create Data Bars in Excel using with Conditional formatting in tamil -    • How to Create Data Bars using with Conditi...  

How to add data bars to pivot table -    • Add Data Bars to Pivot Table in Excel in T...  

How to use color scales in excel -    • How to Use Color Scales in Excel in Tamil ...  

conditional formatting in excel
conditional formatting in excel in tamil
conditional formatting
color scales in excel in tamil
how to use color scales with conditional formatting in tamil

#conditionalformatting #excel #excelintamil #advanceexcel #exceltech #advancedexcel #exceltricks #excelformatting #banutrainingtech #basicexcel #colorscales #dataentry #exceltutorial #exceltips #exceltipsandtricks #exceltutorialintamil #exceltutorialforbeginners #excelinterview #excelforbeginners