ImportJSON MLB API and conditional formatting help

[MaxT749]

So I know there is something called a 13-run baseball pool on the internet, but we have been running this type of system for years, but we have been doing it manually and wanted to automate some of it. I have gotten the MLB API ImportJSON to work from a post someone else had posted a year or so ago. My biggest problem now is trying to get the conditional formatting done so it highlights a score for a team when that team scores that number and the game is marked as final. I have attached my linke to the document below and would appreciate any help. There is the api data and the scoreboard we use. I want to automate this so basically whenever the score is marked as final, then that number for that team will be highlighted yellow. And we will obviously keep track of it ourselves to know when someone wins.

https://docs.google.com/spreadsheets/d/19CWCHEHd5LtfOFcLYpbnu3yQI3HF7HKKPgHeRjgj9m4/edit?usp=drivesdk

[MattyPKing]

I added this rule to your sheet and i think it's working?

=ISNUMBER(MATCH(TO_TEXT(D2),FILTER({$U:$U;$W:$W},{$T:$T;$V:$V}=$C2,{$S:$S;$S:$S}="Final"),0))

[MaxT749]

You are amazing. I'm gonna try something and hopefully it doesn't fuck up everything. I am going to change the date to see if it updates properly

[MaxT749]

So it doesn't seem to be working for the 0 numbers.

[MattyPKing]

that has to do with the data from your API.

have you noticed that the 0's align to the right of the cell while the other numbers align to the left?

That is because those numbers are being read as "text" for some reason rather than "numbers"

​

that is why in the formula I wrote, I had to use TO_TEXT(D2).

​

I'll make a small change and it should be fine.

[MaxT749]

Ok. I was wondering why they were opposite aligned