Conditional format row based on 1 column.

[FStuttgen]

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?

 

[T. Valko]

Try this:

Select the range of cells. Assume this range is A1:F10
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=$E1="Yes"
Click the Format button
Select the Patterns tab
Select a nice shade of blue
OK out

 

[FStuttgen]

Actually, that is what I had tried before posting, but I tried it again on a
subset of my data (A1:F6). What I end up with is Ax pretty blue (where Ex
containx yes), but not the entire row from A-F. Am I missing a step?

 

[T. Valko]

It sounds like you selected just A1:A6. Select the *entire* range of cells
you want to format. If your range is A1:F6 select the *entire* range. Also
make sure you enter the formula so that column E is an absolute reference:
$E1