Custom Rule If C2:C1000 says Tier 2 or Tier 3 AND D2:1000=False then A2:A1000 highlighted Red
I'm sure there is a way to do this, I'm just note sure the best way to go about it. Any ideas? Would it help if C2:C1000 was a drop down menu instead of typed words?
Trying to make a spreadsheet for my school. If a student is in Tier 2 or 3, they need a Support Plan. I'm making a list of all the students in Tiers 1-3, but if Tiers 2 or 3 don't have a Support Plan I want it to be highlighted in red.