How to check two dates and the [total] value on each date to set a color rule

[Tiger1]

I want to check my date column.  In the [date] column I want to check between - today's date and yesterdays date.  I want to check if the [total] from yesterday is smaller or bigger than todays.  Also, this needs to be PER [location] column and per [ category] column: