I want cells that need to be filled in with values to be highlighted. Like, if A2 and B2 contain a value, highlight C2. Only problem is that C2 has a formula so it's not technically "blank". And I want the formatting to go away once the formula has been overwritten.
The formula is there because if someone indicates "Y" in B2, then the value in C2 gets copied into C3.