Google Sheets: Conditional Formatting based on Different Pages

telf 0
Viewed 18

Id like to do some conditional formatting on a spreadsheet I use for keeping track of VODs for a game. Couldn't find the solution online so I thought id ask here.

The Spreadsheet:

https://docs.google.com/spreadsheets/d/1UjYwY1Q5c31wb86lT1s1cgGFcL_LVaIcbxgDf8TMJ7E/edit?usp=sharing

The Problem:

I want to use some conditional formatting to highlight cells in red on the "VodsReviewed" page IF that corresponding cell for the corresponding PlayerName to the same "Event" on the "VodsUploaded" Sheet had a checkbox ticked. I have manually inputted an example of what it might look like for the "Event 7" column in the "VodsReviewed" Sheet.

Many Thanks if you take the time to reply!

formatting google-sheets
1 Answers

try:

=(C2="")=INDEX(IFNA(VLOOKUP(C$1&$B2, SPLIT(FLATTEN(
  INDIRECT("VodsUploaded!B1:1")&INDIRECT("VodsUploaded!A2:A")&"×"& 
 (INDIRECT("VodsUploaded!B2:Z")=TRUE)), "×"), 2, 0)))

enter image description here

player00
Related