Conditional Formatting for Dates Missing Numbers (i.e. 3/11/202 instead of 3/11/2026)
Does anyone have a formula for formatting dates that are missing numbers? I have created a complex tracker, but it cannot do its job if the user does not enter the date right. I know I cannot stop user error, but I am hoping that it could mitigate some of it if the cell turns bright red when they have done something wrong.
I tried and the "ISDATE" function is not working for me. Additionally, I do have text in the document that I do not want formatted so I was playing around with =AND(ISNUMBER(A3),... as the beginning, but could not figure out an end. I also tried typing out an "example date" and having the formula reference that formatting and highlighting the incorrect dates, but I could not get that to work either.
Any help is greatly appreciated, please let me know if you have any questions!
[link] [comments]
Want to read more?
Check out the full article on the original site