Forum Discussion

EMMAGOUGH's avatar
EMMAGOUGH
Copper Contributor
Sep 14, 2022
Solved

Help with IF/THEN functions for DOB checks on excel

Hi,   We have a spreadsheet where I would like a column to highlight if somone is under/over 18 and another column if someone if under/over 21.   I have the DOB in this format 06-May-2002 (for ex...
  • Riny_van_Eekelen's avatar
    Sep 14, 2022

    EMMAGOUGH 

    Conditional Formatting will do just that. On the web it looks slightly different than on the desktop, though. Attaching a file that you can open in the web version and see how it's done.

     

     

Resources