=match($F12, indirect("'rangeTab'!$B$12:$B") ,0)
I have used the following formula to highlight a whole row based on the contents of one cell:
=$O1="Yes"
Krevitt now has me wondering what else I could do.
📑 Conditional color formatting with custom formulas in Sheets
David Krevitt walks through creating a custom formula for conditional formatting. He is correct in saying that there are not many posts or reflections written about this. The formula that he uses (which can be found here) highlights a value found in a separate list in a separate tab:
tag:twitter.com,2013:957852038913806337_favorited_by_4472228655
Coding is for Losers
losersHQ
https://twitter.com/mrkrndvs/status/957852038913806337#favorited-by-4472228655