Conditional Format based on Date of Birth

[Christopherdj]

Wondering how you apply conditional formatting to an entire row based on a date of birth in row C.
The criteria is if the person is UNDER the AGE of 18 as of the current day.
I need the entire row highlighted not just the cell, in any colour (pink, light orange, light green, any light colour) based on the date of birth which is shown as dd/mm/yyyy.
If I need to add the current date into another sheet, that's fine, data can be in Sheet 1, the date can be in Sheet 2 but it needs to update each day automatically - my file only has one sheet which contains a lot of personal data but the DOB is in column C.
Does anyone have an option for me? Thanks in advance.

[jeffreybrown]

Try this...

In D2 copied down is where I stored the age. =DATEDIF(C2,TODAY(),"y")

You could put this into the CF, but here I just used a helper cell.

Conditional Formatting

• Highlight applicable range >> A2:L200
• Home Tab >> Styles >> Conditional Formatting >> New Rule
• Select a Rule Type: Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =AND(N($D2),$D2<18)
• Format… [Number, Font, Border, Fill]
• OK >> OK

I don't know your range, so adjust the A2:L200 to the range you need to highlight.

[Christopherdj]

Brilliant, thanks for the quick reply and it works. Great stuff.

[jeffreybrown]

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.