I would want the red to be highlighted in the row that the value is present.
So for example:
if 1 day is entered in C10, then G10-J10 would need to turn red, if there is no value in those cells. If someone put information into those cells, then the red would clear away.
I guess we are trying to show customers what cells they need to fill out based on if they enter 1 or 2 days. Then when they fill those required cells out, it looks completed.
Would be way easier to explain with seeing the spreadsheet darn it!