Highlight cell if date is less than one year

**Tashia** · 11-02-2017, 04:27 PM

Hello,

I would like to highlight dates that are less than one year from today. Thank you in advance

Example highlight the date 12/01/17

**alansidman** · 11-02-2017, 04:36 PM

Where are your range of dates located in your spreadsheet?

**Tashia** · 11-02-2017, 04:41 PM

Dates are in A2 through A6

**alansidman** · 11-02-2017, 04:54 PM

You could use Conditional Formatting.

https://exceljet.net/conditional-for...-with-formulas

**samba_ravi** · 11-02-2017, 04:58 PM

select from A2:A8
and use below formula in conditional format
=a2>EDATE(TODAY(),-12)
home>conditionalformat>managerules>newrule>use a formula to determine which cell to format

Highlight cell if date is less than one year

LinkBack

Thread Tools

Rate This Thread

Display

Highlight cell if date is less than one year

Re: Highlight cell if date is less than one year

Re: Highlight cell if date is less than one year

Re: Highlight cell if date is less than one year

Re: Highlight cell if date is less than one year

Thread Information

Users Browsing this Thread

Similar Threads

Remove or highlight row with date only within one year

Highlight whole row if date falls on a Sunday / Add Year

Date Highlight that will go over a year

I need to highlight a cell when a date is 2 and 1 motths away from being half a year

[SOLVED] Need help with conditional formatting dates to highlight 1 year after cell date

[SOLVED] Conditional Formatting: Highlight a cell containing a date after 1 year past that date!

[SOLVED] Conditional Formatting a cell to highlight "red", after passing one year expiration date

Bookmarks

Bookmarks

Posting Permissions