When you work on multiple datasets with various information, you may find it difficult to present them in the default format. Because this bulk of worksheets will create nothing but confusion, especially during a presentation. This is why we need to make excel spreadsheets colorful to define certain information. In this article, we will learn how to make an excel spreadsheet colorful with 6 simple techniques.
Download Workbook
Get the sample file here to practice by yourself.
6 Simple Tricks to Make Excel Spreadsheet Colorful
For example, we have a dataset here representing the grade sheet with the progress of 5 students.
Now we will use the 6 techniques below to make this excel spreadsheet colorful:
1. Use Fill Color Tool to Make Colorful Spreadsheet in Excel
In this first technique, we will use the Fill Color tool in excel to make a colorful spreadsheet. Follow the steps below:
- First, select the cells that you want to color.
- Here, we have selected the header cell range B4:E4.
- Following, go to the Home tab and click on the Fill Color icon in the Font section.
- Then, select any color from its drop-down section.
- Otherwise, select More Colors for more coloring options.
- Now, choose any customized color from the Color window.
- Finally, our header cells are colorful. We have also colored other cells where it was necessary following the same process.
- You can also change the color of any font by choosing a color from the Font Color section.
Read More: [Fixed!] Background Color Not Changing in Excel (6 Solutions)
2. Apply Conditional Formatting to Make Excel Spreadsheet Colorful
Conditional Formatting helps to make the excel spreadsheet colorful based on certain conditions (i.e. values, numbers). It represents the spreadsheet in a more specific way to look into certain outputs. Let’s see how it works.
- First, select cell range E5:E9.
- Secondly, select Conditional Formatting from the Home tab.
- After that, choose the condition Greater Than from the Highlight Cells Rules options.
- Following, the Greater Than window opens.
- Here, insert cell E9 as the condition the cells’ value of more than 67% will be highlighted.
- Then, press OK.
- That’s it, you can see that the cells greater than the value of cell E9 are highlighted.
- You can also apply other conditions from the Conditional Formatting drop-down section.
- In case you need to edit the applied condition, go to Manage Rules.
- Thereafter, a new window Conditional Formatting Rules Manager pops up.
- Now, click on Edit Rule.
- Here in the Edit Formatting Rule, select the rule type as Format only cells that contain.
- In the Edit the Rule Description box, change the conditions that you may like. Our’s one is marked in the below image.
- Next, press OK.
- After this, click on Apply and then press OK.
- Finally, you can see the cells are highlighted according to the new condition.
Read More: How to Change Background Color Based on Value in Excel
3. Make Colorful Spreadsheet with Format as Table Tool
Another technique to make the spreadsheet colorful is with the Format as Table tool in excel. Following is the process for this:
- In the beginning, select Format as Table from the Home tab.
- Following, select any style of the table from the drop-down section.
- Now, insert cell range B4:B9 in the Create Table window.
- Finally, the spreadsheet is made colorful with the help of the Format as Table tool.
- In case you need to customize the table, go to the New Table Style.
- Now, format the table elements however you want in the New Table Style window.
- In the end, press OK.
Read More: How to Change Cell Background Color with VBA in Excel (2 Cases)
Similar Readings
- How to Make Excel Easier on the Eyes (12 Quick Tips)
- Make Excel Look Pretty (16 Easy Formats)
- How to Print Background in Excel (With Easy Steps)
- Make an Excel Spreadsheet Look Like a Form
- How to Change Background in Excel Sheet (4 Suitable Ways)
4. Apply Themes to Make Spreadsheet Colorful
In this technique, we will apply Themes to make the spreadsheet colorful by following the steps below:
- First, select Themes from the Page Layout tab.
- Secondly, select any of the theme styles from the dropdown.
- After this, choose a color palette from the Colors option in the Themes section.
- Otherwise, click on Customize Colors from the drop-down.
- Then, for each theme color you want to change, click the button next to that color, and pick a color under Theme Colors in the Create New Theme Colors window.
- In addition to that, you can customize colors from the More Colors options.
- In case you want to change the lettering and animation style of the spreadsheet, explore the Fonts and Effects tools.
- To save your preferred theme, click on Save Current Theme.
- After that, insert the File name and press Save.
Read More: How to Change Background from Black to White in Excel (3 Ways)
5. Modify Worksheet Tab Color in Excel
So far we have only discussed making the rows and columns colorful. Now we will color the worksheet tabs in excel. Let’s see the step by step process below:
- First, right-click on any of the worksheet tabs and choose Tab Color.
- Then, choose any of the Theme Colors from the options.
- To customize colors, go to More Colors.
- Finally, you can see the worksheet tabs are now colorful.
- To remove the worksheet tab color, do the same procedure. Just in this case, select the No Color option from the Theme Colors.
- On the other hand, you can find the same feature in the Excel ribbon.
- Here, select Format in the Cells section of the Home tab.
- Then, click on Tab Color.
- Finally, you can see similar coloring options in this section.
Read More: How to Change Worksheet Tab Color in Excel (5 Handy Methods)
6. Change Gridline Color in Spreadsheet
In this last technique, we will color the gridlines in the spreadsheet. Let’s see the method below:
- In the beginning, go to File from the Excel ribbon.
- Then, select Options from the left panel.
- Now, select Advanced from the new Excel Options window.
- After that, go to Display options for this worksheet section.
- Select any color from the Gridline Color section.
- Next, press OK.
- Therefore, the spreadsheet will look like this:
Here is another way to color the gridlines:
- First, select the whole spreadsheet by pressing Ctrl + A or clicking on the triangle as shown below:
- Then, choose the More Borders icon in the Font section of the Home tab.
- After that, select Line Color and choose any color from the Theme Colors.
- Now, select All Borders from the same drop-down section.
- Finally, the gridlines are colored here in the excel spreadsheet.
- You can modify the line thickness from the Line Style.
- To format the gridlines, go to More Borders.
- Here, in this Format Cells window, customize the gridlines however you want.
Read More: How Do I Change the Default Background Color in Excel
Conclusion
Concluding the article with the hope that, it was a helpful one for you on how to make the excel spreadsheet colorful with 6 simple techniques. Let us know your suggestions in the comments section. Follow ExcelDemy for more excel blogs.
Related Articles
- Excel VBA to Open Workbook in Background (2 Useful Examples)
- How to Make Picture Background Transparent in Excel (2 Methods)
- Make Excel Look Like an Application (with Easy Steps)
- How to Remove Background in Excel (2 Practical Cases)
- Add Background Image Watermark in Excel (with Easy Steps)
- How to Remove Background Color in Excel (5 Ways)