I have a table where the first column is a list of dates. The dates are in order, but some dates are skipped, and sometimes the date is repeated several times. My goal is to create conditional formatting so that a date cell is highlighted ONLY IF the date directly above it is at least 2 days before it (e.g. if the date in cell A5 is 3/11, it won't be highlighted if the date in cell A4 is either 3/10 or 3/11, but it will be highlighted if the date in cell A4 is anything before 3/10). New dates are added to the table all the time, so i would need a function that conditionally formats every new cell as it is entered. Is this possible?
Bookmarks