How to Color Code Cells in Excel Worksheets

Microsoft Excel is a great and versatile software in the Microsoft Office bundle. By using conditional formatting, you can do the cell formatting with the inserted value in Microsoft Excel. In case you are making a spreadsheet for your maths class and wish to color the irrational number cells, then you need to follow the steps mentioned below.

Here’s How to Color Code Cells in Excel Worksheets

•    Highlighting the Duplicates

1.    Firstly, you have to choose the cells range.

2.    Click on the Control and A keys together to choose each cell given in the table.

3.    Click on the Home option.

4.    Go to the Conditional Formatting.

5.    Below the Conditional Formatting option, click on the Highlight Cell Rules option.

6.    After that, click on the Duplicate Values option.

7.    Now, you will get a new window which let you choose the format by going to the pull-down menu.

8.    The pull-down menu permits you to select which cells you wish to color.

9.    The other pull-down menu provides you colors which are available.

10.    Click on the OK button.

•    Sort by Color in Excel

1.    Choose the preferred data range.

2.    Click on the Data option.

3.    Press on the Sort and Filter option.

4.    Click on the Sort option.

5.    Choose the preferred section given in the data range.

6.    Choose the Cell Color for the Sort on option.

7.    Select the color located in the Order option.

8.    Choose the On Top option.

9.    It is located in the pull-down menu.

10.    Click on the OK button.

•    Highlighting the First 10

1.    Click on the Home option.

2.    Press on the Conditional Formatting option.

3.    Click on the Top or Bottom Rules.

4.    Choose the Top 10 Items option.

5.    Now, you will get a new window.

6.    You need to change the number of options as per your wish.

7.    Choose the fill color.

8.    Press on the OK button.

You can choose the advanced options which are mentioned below:

•    Showing Variances with Data Bars

1.    Click on the Home button.

2.    Go to the Conditional Formatting option.

3.    Click on the Data Bars option.

4.    Choose the preferred color.

5.    After that, select the style.

•    Highlighting Positive, Negative, Neutral Values with Icons

1.    Choose the row or range which you wish to format in Excel.

2.    Click on the Home button.

3.    Go to the Conditional Formatting option.

4.    Click on the Icon Sets option.

5.    Select the icon style which you wish to use.

6.    In case you wish to change it, then click on the Manage Rules option.

7.    It is given below the Conditional Formatting option.

8.    Select the Icon Set rule.

9.    After that, press on the Edit Rule option.

10.    Change the rules as per your wish.

•    Showing Variances with Different Color Scales

1.    Choose the range.

2.    Search for the Color Scales option.

3.    It is located in the Conditional Formatting option.

4.    Select the color scale.

Source url:- http://setup-request.net/how-to-color-code-cells-in-excel-worksheets/

Mike Smith is a creative person who has been writing blogs and articles about cyber security. He writes about the latest updates regarding norton.com/setup and how it can improve the work experience of users. His articles have been published in many popular e-magazines, blogs and websites.