Conditional Formatting for discrete rows (two part question)

First, I've searched and seen a number of answers to similar questions and tried/failed each one. Here's the scenario:   I have a table of citizen science data about 100 columns (historic years) by...