I'm trying to add a little functionality in my register to help me catch incorrectly entered dates. I've got a column, A, for dates where no date entered should be earlier than the previously entered date. Normally I'd use if "Date is Before" the "Past Week" or so, but I'm not necessarily going to be entering dates every week or every two weeks.
So my desired functionality is "highlight red if date is before date entered in the cell above." I'd also like to add "highlight orange if date is equal to date entered in the cell above." How do I accomplish this? I'm aware of the
ISDATE functions, but the documentation is a little confusing to me and I don't entirely understand how to use them.