Hello all, I'm trying to use conditional formatting to highlight the row of data with a date that is closest to today but not in the future.
I am currently using =$A2=TODAY() in conditional formatting, but this will not highlight the date if today's date is not on the list. I would like to highlight the last in the series of dates that's closest to today but not in the future.
Can someone help?
<tbody>
</tbody>
I am currently using =$A2=TODAY() in conditional formatting, but this will not highlight the date if today's date is not on the list. I would like to highlight the last in the series of dates that's closest to today but not in the future.
Can someone help?
Date | Check # | Payee | Comments | Expense | Deposit | Balance |
1/12/2018 | Deposit | $ 3,500.00 | $7,144.18 | |||
1/12/2018 | Cell Phone | $ 70.00 | $7,074.18 | |||
1/16/2018 | Car Payment | $ 281.58 | $6,792.60 | |||
1/21/2018 | Credit Card | $ 229.00 | $6,563.60 | |||
1/21/2018 | Insurance | $ 44.01 | $6,519.59 | |||
1/21/2018 | Withdraw | $ 60.00 | $1,548.57 | |||
1/29/2018 | Gas and Electric | $ 222.25 | $4,826.32 | |||
<tbody>
</tbody>