[luissotoii]

I need Conditional Formatting to only highlight dates that exceed 50 years of age. Currently I have =((TODAY()-D4)/365<50). It seems to work on some but not all, any suggestions.

[JBeaucaire]

How about this:

=DATEDIF(D4,TODAY(),"y")>=50

[luissotoii]

I normally use the Cell Value Is where I am able to copy and special paste to all 2000 rows. I can not copy and special paste using the Formula Is.

[luissotoii]

I know I may copy and special paste from CELL IS in CONDITIONAL FORMATTING to the remaining 2000 rows. May I copy and special paste from FORMULA IS to the remaining 2000 rows?

[JBeaucaire]

If the formula given above is working properly for the cell in which it is inserted, it will adjust itself properly for each cell you copy it into. The cell reference D4 is relative so should have no problems adjusting for all 2000 rows.

If the formula is being added to MULTIPLE cells on the same row but they all need to watch column D, make that cell reference $D4

[luissotoii]

The formula is acting as chaotic as the formula I had initially. It does show that the formula is moving chronological, but some cells that should be highlighted are not and vice versa. I assumed I was applying it wrong. I can go individually but I don't want that to happen.

[JBeaucaire]

Feel free to post a wb we can look at together. This stuff should be easy, and chaos usually comes from something unexplained going on the wb.

[luissotoii]

Its emailed. You just reply and I'll review it Monday.

[JBeaucaire]

I don't see any attempts at conditional formatting, the point of a sample sheet is to see examples of a few rows of data and what your desired results should be.

[luissotoii]

My apologies, I have forwarded you a new chart.

[JBeaucaire]

You don't need two CF formulas as far as I can see, you should only need 1.

In F2 use this CF formula:

Formula Is: =AND(F2>=75,DATEDIF(A2,TODAY(),"y")>=50)

Then copy that cell downward.

NOTE: I suggested the DATEDIF() thing back in post #2.