Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Apply Shading to Odd or Even Rows/Columns in Excel?
When we are using Excel, we want to add different colours to cells to create a design that can improve the neatness of the data. This also makes the excel sheet look nicer and allows for faster data analysis. This article will help you understand how we can apply colour shading to odd or even rows or columns in Excel. This can be done using a simple method in Excel by using conditional formatting and applying different colours.
Read this tutorial to learn how you can apply shading to odd or even rows or columns in Excel.
Apply Shading to Alternative Rows/Columns Using Conditional Formatting
Here we will first select the range of cells and then apply the conditional formatting using a formula. Let us understand how we can apply shading to odd or even rows or columns using conditional formatting.
Step 1
Let us consider an empty or new Excel worksheet to apply odd or even row colours or column colours.
Now select the range of cells you want to add odd or even row colours to, then click on home on the Excel ribbon, then click on conditional formatting, and then select a new rule as shown in the below image. A new pop-up window will be opened.
Step 2
Now in the new pop-up window, click on the use the formula, then enter the formula as =MOD(ROW(),2) in the formula box, and click "Format", as shown in the below image.
Then a new pop-up window will be opened; click on Fill and select the colour you want to add, then click on OK to successfully apply an alternate colour in Excel in a simple process.
We have successfully added the even row colour to the cell. We can use the same procedure to add the alternate even odd column colour, but we must use the formula =MOD(Column(), 2).
image4
Conclusion
In this tutorial, we used a simple example to demonstrate how we can apply shading to odd or even rows/columns in excel to highlight a particular set of data.
289 Views
