MAIN FORUM

Comments

  • superjon

    I have a spreadsheet.

    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.

  • X Unread Thread
  • X Thread with New Replies*
  • *Jumps to your first unread reply

RotoGrinders.com is the home of the daily fantasy sports community. Our content, rankings, member blogs, promotions and forum discussion all cater to the players that like to create a new fantasy team every day of the week.

If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537) (IL). Gambling problem? Call 1-800-GAMBLER (NJ/WV/PA/MI), 1-800-9-WITH-IT (IN), 1-800-522-4700 (CO), 1-800-BETS OFF (IA), 1-888-532-3500 (VA) or call/text TN REDLINE 1-800-889-9789 (TN).