How to highlight rows with weekend days in excel?

In the article, the users are going to highlight the rows with weekend in Microsoft Excel. There are the several features in the excel sheet including conditional formatting, format cells that the users must fill any type of color according to the need. The users can use the conditional formatting for highlighting the weekends in the row. The users can use select the conditional format to highlight the row one by one in which you want to fill the color in any cell. With the help of this problem statement, finance department may calculate the salary of the employees after highlighting rows with weekend days.

Let’s start the article with the step-by-step explanation to highlight weekend date embed in the rows.

Step 1

Deliberate the excel sheet with the data. First, open the excel sheet and create the data one by one. In this sheet, type the product and its date randomly and it will create a data which the users have to highlight them as shown below.

Step 2

In the excel sheet, the created data is displayed. After creating the rows, place the cursor in the cell A2 and select all the cells which the users inserted the data one by one.

Step 3

After selecting all the data in the sheet, place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. On Home tab, place the cursor and click on the drop-down menu of Conditional Formatting. On this tab, there are many options included. Click on the New Rule button that opens the New Formatting Rule dialog box as shown below.

Step 4

In the dialog box, there are the rules included one by one. Select and click on the rule Use a formula to determine which cells to format that enables the drop-box like this.

Step 5

In the dialog box, there is the input type and place the cursor on it. Now, enter the formula =WEEKDAY($B2,2)>5 to highlight only weekends in the date field as shown below

Step 6

In the dialog box, place the cursor and click on the Format button that opens a new dialog box Format Cells that has the Fill tab like this.

Step 7

In the dialog box, choose any color in the color theme as shown which the users want to highlight only weekends then click on the OK button that closes the dialog box of Format Cells.

Step 8

After closing the Format Cells dialog box, the New Formatting Rule dialog box will display as shown below.

Step 9

In the dialog box, click on the Ok button that will close the New Formatting dialog box. After closing the dialog boxes, it will highlight only weekends with the selected color from color theme randomly as shown below.


The users utilized an easy instance to display how can highlight the rows that have only weekends with different colors randomly. The users used the necessary tabs which are included in the ribbon. The users must practice the essential options from ribbon and modify the data according to the need.

Updated on: 12-Apr-2023


Kickstart Your Career

Get certified by completing the course

Get Started