How to Highlight cell with Date Value Greater Than 6 months

[Burner01]

Hey everyone,

I'm a newbie and would appreciate any assistance you all can give me!

I'm trying to figure out how to highlight a specific cell if the date value in that specific cell (returned from the formula shown below) has a date value equal to or greater than 6 months and 1 day.

The formula I'm using to calculate the length of time between two dates is the following:

=DATEDIF(B2,B3,"y")&" Year, "&DATEDIF(B2,B3,"ym") & " Months, "&B2-DATE(YEAR(B2),MONTH(B2),1)&" Days "

I look forward to being amazed!

Thank You!

[Special-K]

Use Condtional Formatting

Select the range of cells to highlight

Conditional Formatting
New Rule
Use a formula to determine...

This will highlight when cell A1 (change it as required) is older than 6mths
=a1 < edate(today(),-6))

If you mean the cell is to highlight within the next six months use this

=AND(A1 > TODAY(),a1 < edate(today(),6))

Format as required

[Burner01]

Thanks for the response!

I don't need the formula to highlight it the value is more than 6 months from today...

I need the cell to highlight if the date range value calculated in the cell is 6 months and 1 day or greater...

Sort_6.jpg

[FDibbins]

So change the sign around and drop the TODAY()

[Burner01]

Just tried that...didn't seem to work

[johnmpl]

Hi, to all!

You could try this:

1. Select Range C3:C8 (with activecell in C3)
2. Go to Home - Conditional Formatting - New Rule - Use a formula to determine...
3. Put this formula:

=EDATE(B2,6)<B3

4. Give the format you want, and done!

Blessings!