Conditional formatting on row based on text result from formula from another cell

ebella212 

All formatting is shifted by one row. The format of row 1 is determined by Yes or No in row 2, and row 2's format depends on row 3 etc. 

This is because you apply a rule looking at $U2 applied to entire columns F:T that start in row 1.

So, change $U2 into $U1 or set the applied range to $F$2:$T$5000, for example. Any range big enough to capture all rows with data. Avoid using references to whole columns as the may slow down your file if you have many of them.