Forum Discussion
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...
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.
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.
This has worked! Thank you so much for your help and for responding so quickly!