Conditional Formating

[Carefree101]

In the DOB row under the number column I need it to highlight if the person is over 80 years old, for example 01/01/1939 - Highlight light blue. I just can't get my head around this for some reason the formating isn't working.

Any Suggestions please? I can't use date occuring obviously and when I put it in as a value between it doesn't work. Is there a easy formula I could use? TIA

 

[Fluff]

You could use some thing like

=AND(B8<>"",B8<=EDATE(TODAY(),-960))