How to Highlight Dates Older Than 30 Days in Excel

This post will guide you how to highlight dates older than 30 days in Excel. How do I use conditional formatting to highlight if date is greater than 30 days old in Excel. How to highlight a row or cell if it’s older than x days in Excel.

Highlight Dates Older Than 30 Days


Assuming that you have a list of data in Range B1:B5, in which contain date values. And you need to format all date values if the dates are older than 30 days then highlighting the cells. You can use the Conditional Formatting feature to achieve the result of highlighting dates older than X days. Here are the steps:

#1 select the range that contain date values you want to highlight.

highlight dates older than 30 days1

#2 go to HOME tab, click Conditional Formatting command under Styles group. And select New Rule from the drop down menu list. And the New Formatting Rule dialog will open.

highlight dates older than 30 days2

#3 select Use a formula to determine which cells to format option under Select a Rule Type list box, and type the following formula into Format values where this formula is true text box.

=B1<TODAY()-30

highlight dates older than 30 days3

#4 click Format button in the New Formatting Rule dialog, and the Format Cells dialog will open. Click Fill tab in the Format Cells dialog, and choose one color as the background color to highlight cells. Click Ok button.

highlight dates older than 30 days4

#5 click Ok button. All date values are older than 30 would be highlighted in the selected range of cells.

highlight dates older than 30 days5

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar