Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Excel Conditional Formatting for Date Within 3 Months (3 Methods)

Conditional Formatting is a handy feature to highlight cells based on a specified condition. If you want to know how to use Conditional Formatting for date within 3 months in Excel, you have come to the right place. Here, we will walk you through 3 easy methods to do the task smoothly.

Download Practice Workbook

You can download the Excel file and practice while you are reading this article.


3 Methods to Use Conditional Formatting for Date Within 3 Months in Excel

The following dataset has the Project and Date columns. In the Date column, you can easily notice that we have taken 29-08-22 as the first date, and all the other dates are ahead of 29-08-222. Next, using the dataset we will go through 3 methods to conditional formatting date within 3 months. Here, we used Microsoft Office 365 to do the task. You can use any available Excel version.

Conditional Formatting Date Within 3 Months


1. Using Between Option of Conditional Formatting

In this method, we will use the Between option of Conditional Formatting for Conditional Formatting date within 3 months.

Steps:

Let’s go through the following steps to do the task.

  • First, we will select cells C5:C13.
  • After that, we go to the Home tab >> select Conditional Formatting.
  • Then, from the Highlight Cells Rules group >> select Between.

At this point, a Between dialog box will appear.

  • Furthermore, we set a range between 24-08-22 and 24-11-22.
  • Afterward, we set Light Red Fill with Dark Red Text as the color.
  • Then, click OK.

Using Between Option for Conditional Formatting Date Within 3 Months

As a result, you can see dates that are within 3 months are highlighted with light red color.

Hence, we can conditional Formatting date within 3 months.

Read More: Conditional Formatting Based on Date Older Than 1 Year in Excel


2. Conditional Formatting Date Within 3 Months Using AND and TODAY Functions

In this method, we will use the combination of AND and TODAY functions to conditional formatting dates within 90 days.

Steps:

Let’s go through the following steps to do the task.

  • First of all, we will select cells C5:C13.
  • Moreover, we will go to the Home tab >> select Conditional Formatting.
  • Furthermore, select the New Rule.

At this point, a New Formatting Rule dialog box will appear.

  • After that, we select Use a formula to determine which cells to format from the Select a Rule Type box.
  • Furthermore, we type the following formula in the Format values where this formula is true box.
=AND(C5>=TODAY(), C5<=(TODAY()+90))

Here, we used the AND function where we used two logical conditions for the used Date range. Where the conditions are the Date has to be greater than or equal today and less than or equal TODAY()+90. Here, we used the TODAY function to get the date of today. If it fulfills the conditions then it will Fill Blue color to the respective dates.

  • Next, we click on Format.

Excel Conditional Formatting Date Within 3 Months by Using TODAT and AND function

Afterward, a Format Cells dialog box will appear.

  • Furthermore, from the Fill group >> we select a Blue color.

Here, in the Sample box, you can see the sample color.

  • In addition, we click OK.

Selecting color for Conditional Formatting Date Within 3 Months

Moreover, you can see the Preview in the New Formatting Rule dialog box.

  • After that, click OK.

Therefore, you can see dates that are within 3 months are highlighted with blue color.

As a result, we can conditional Formatting date within 3 months.

Read More: Conditional Formatting for Dates Older Than Certain Date in Excel


Similar Readings


3. Using TODAY Function for Conditional Formatting Date Within 3 Months

Here, in the following dataset, you can easily notice that Order Date includes dates that are behind the date 29-08-22,  and along with that there are dates that are ahead of the date 29-08-22. In that case, we will use the TODAY function for conditional formatting dates within 3 months.

Steps:

Let’s go through the following steps to do the task.

  • In the beginning, we will select cells C5:C13.
  • Moreover, we will go to the Home tab >> select Conditional Formatting.
  • Afterward, select the New Rule.

Next, a New Formatting Rule dialog box will appear.

  • After that, we select Use a formula to determine which cells to format from the Select a Rule Type box.
  • Moreover, we type the following formula in the Format values where this formula is true box.
=C5>TODAY()-90
  • In addition, we click on Format.

Applying TODAY Function for Conditional Formatting Date Within 3 Months

At this point, a Format Cells dialog box will appear.

  • After that, from the Fill group >> we select a light Orange color.

Here, in the Sample box, you can see the sample color.

  • Then, we click OK.

Moreover, you can see the Preview in the New Formatting Rule dialog box.

  • Afterward, click OK.

As a result, you can see the dates are 3 months after and before today have been highlighted with light Orange color.

Hence, we can conditional Formatting date within 3 months.

Read More: How to Find If Date Is Within 3 Months in Excel (5 Easy Ways)


Practice Section

You can download the above Excel file to practice the explained methods.


Conclusion

Here, we tried to show you 3 methods for conditional formatting date within 3 months. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.


Related Articles

Afia Kona

Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo