RSVPed Interested in Attending https://learn.codingisforlosers.com/the-google-sheets-query-function
The Query function is the shortcut to mastering Google Sheets. Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query. If you're working with data in any capacity - even if it's just to produce a monthly report - you'll want to know how to run Queries. This course teaches Querying interactively, by working through a sample analysis of Twitter data in Google 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:

=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.