Conditional Formatting 2 columns

[LookieHere]

First of all, Excel is def not my forte. And Im a newbie, just discovered this site. First post!

I am a member of a private social club.
I need help calculating when a member is eligible for lifetime membership.


Requirements:
When a member reaches age 60 (DOB)
and
They have been a member for 25 years (JOIN DATE)
We have over 800 members that I have yet to enter their information.

I don’t know if it would be easier to highlight the cells when those 2 criteria’s are met or maybe another column showing lifetime member eligibility date? The second option would be preferred.
There is no sensitive information in the spreadsheet. Ive been trying to figure this out but I just cant get it done.

Any help would be GREATLY appreciated!!

MemberListInfo.xlsx

[HansV]

Welcome to Eileen's Lounge.

Insert a new column in the table, for example to the right of the JOIN DATE column.
Name this column ELIGIBLE or similar.
Enter the following formula in row 2 of the new column:

=IF([@DOB]="","",AND(DATEDIF([@DOB],TODAY(),"Y")>=60,DATEDIF([@[JOIN DATE]],TODAY(),"Y")>=25))

Excel should automatically fill the entire column with this formula.

You can easily filter the column for TRUE or FALSE.

See the attached version.

MemberListInfo.xlsx

[LookieHere]

Hans,
Thank you so much. I truly appreciate. Just curious for my own sanity, how long did that take you? :)

[HansV]

It took me about 5 minutes - I've answered many similar questions over the years...

[stuck]

Here's an 'old school' version that doesn't use a Table and colours the rows using the conditional formatting rule:
=AND(DATEDIF($G2,TODAY(),"y")>=60,DATEDIF($H2,TODAY(),"y")>=25)
that applies to the range:
=$A$2:$H$7

Ken
edited to add: this where Hans points out the flaw in my version

[HansV]

[stuck]

an but, as yet no flaw reported...

[HansV]

Your conditional formatting formula works perfectly.
The only difference with the formula that I proposed is that I added a condition to avoid reporting/highlighting rows where the date of birth hasn't been entered yet.