How to use conditional formatting to highlight information after using =DATEDIF to calculate age?

New Contributor

Hi everyone, this is my first time here.

I already using =DATEDIF(E3,TODAY(),"Y") & "Y" & DATEDIF(E3,TODAY(),"YM") & "M" to calculate their age, after that, I would like to use conditional formatting to highlight those results over 59Y05M, what should I do?


2 Replies
best response confirmed by Jeffkcl (New Contributor)

@Jeffkcl You can use rule from the "Highlight Cells" group, Greater Than...


Screenshot 2022-05-06 at 07.33.47.png

And then just type 59Y05M in the box to the right of "greater than". It will create rule like this:

Screenshot 2022-05-06 at 07.34.20.png 

and result in formatting like this:

Screenshot 2022-05-06 at 07.38.45.png

The above screenshots were taken on a Mac, but it's very similar on the PC version of Excel.

Oh! It's work! But it didn't work before,
Anyway, thanks so much!