Types of cell formatting in excel

Hello Liam,

Create a copy of excel sheet and follow these steps on a excel copy to prevent Loss of Data.

Select the range where you want the formatting to apply:

In your case, select the range from B6 to AF(whatever the last row is).

Go to the "Home" tab:

Click on the "Home" tab in the Excel ribbon.

Click on "Conditional Formatting":

Under the "Home" tab, find the "Conditional Formatting" option.

Choose "New Rule":

From the dropdown, select "New Rule."

Select "Use a formula to determine which cells to format":

Choose this option to create a custom formula for your conditional formatting.

Enter the following formula:

1. For example, if your selected month is in cell B3, and the current cell is C6, use the following formula to check if the day is a weekend and if the month matches:

This formula checks if the day is Saturday (6) or Sunday (7) and if the month is December.

Adjust the month reference as needed.

Set the format:

Click on the "Format" button to set the formatting options, such as shading.

Click "OK" to apply the rule:

Confirm your settings and c

how to format axis range in excel

how to format data range in excel