# MAIN FORUM

• superjon

It has a column with dates. Let’s say column A. The dates are in descending order.

Ex.

A1 = 10/26/2017
A2 = 10/25/2017
A3 = 10/23/2017
,etc…

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.

TIA

• rebkell

Highlight all of Column A, Home->Conditional Formatting->New Rule-> Use a formula to determine which cells to format
Formula would be =A2-A1=1 then pick your colors and ok it.

Edit:Sorry I wasn’t paying attention to the order, change the formula to =A1-A2=1

• superjon

@rebkell said...

Highlight all of Column A, Home->Conditional Formatting->New Rule-> Use a formula to determine which cells to format
Formula would be =A2-A1=1 then pick your colors and ok it.

That’s the first I tried but couldn’t get it to work for some reason.

I did find a work around.

Basically created a second column that subtracts the dates. So B1 = A2-A1. B2 = A3-A2. And so on… Then I can just filter to only show cells with the value “-1” and that will give me all B2B games.

• nloc

You could use the IF formula.