Conditional Formatting

[Crewchief521]

i have a spreadsheet setup with the NBA schedule. What i am trying to do is conditional format if a team played yesterday (back to back). its set up like this:

12/29/2019	6:00p	Oklahoma City Thunder	98	Toronto Raptors	97
12/29/2019	8:00p	Charlotte Hornets	104	Memphis Grizzlies	117
12/29/2019	8:00p	Houston Rockets	112	New Orleans Pelicans	127
12/29/2019	8:00p	Sacramento Kings	115	Denver Nuggets	120
12/29/2019	9:30p	Dallas Mavericks	95	Los Angeles Lakers	108
12/30/2019	10:00p	Phoenix Suns		Portland Trail Blazers
12/30/2019	7:00p	Atlanta Hawks		Orlando Magic
12/30/2019	7:00p	Miami Heat		Washington Wizards
12/30/2019	8:00p	Brooklyn Nets		Minnesota Timberwolves
12/30/2019	8:00p	Milwaukee Bucks		Chicago Bulls
12/30/2019	9:00p	Detroit Pistons		Utah Jazz

so with this data set i know that i will return 0 results because neither of these teams playing today (12/30/19) played yesterday (12/29/19), but in the instance they do i want to highlight them. i do have a cell (T1) that is formatted =today()-1 to retrieve yesterdays date. Any help would be appreciated, Thanks!!

 

[6StringJazzer]

I see the error, my apologies. I set up a test file and this definitely works:
=(COUNTIFS($M$6:$M$1235,M6,$K$6:$K$1235,$K6-1)+COUNTIFS($O$6:$O$1235,M6,$K$6:$K$1235,$K6-1))>0

Dropbox - File Deleted - Simplify your life

www.dropbox.com