My spreadsheet is hundreds of rows but only 6 columns. I want all 6 fields of
a row to have conditional formatting based on the data in column E. i.e., if
E5 is "yes" all boxes of row 5 have a blue background. If E5 later changes to
"no", the row changes back to white.

Possible?