I have a spreadsheet.
It has a column with dates. Let’s say column A. The dates are in descending order.
A1 = 10/26/2017
A2 = 10/25/2017
A3 = 10/23/2017
I would like a formula that would highlight the cell if the difference between it and the cell below was equal to “1” So in the example above, cell A1 would be highlighted.