Conditional format row based on 1 column.
 

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?

Conditional format row based on 1 column.
 

Try this:

Select the range of cells. Assume this range is A1:F10
Goto the menu FormatConditional 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

--
Biff
Microsoft Excel MVP


"FStuttgen" wrote in message
...
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?

Conditional format row based on 1 column.
 

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" wrote:

Try this:

Select the range of cells. Assume this range is A1:F10
Goto the menu FormatConditional 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

--
Biff
Microsoft Excel MVP


"FStuttgen" wrote in message
...
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?

Conditional format row based on 1 column.
 

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

--
Biff
Microsoft Excel MVP


"FStuttgen" wrote in message
...
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" wrote:

Try this:

Select the range of cells. Assume this range is A1:F10
Goto the menu FormatConditional 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

--
Biff
Microsoft Excel MVP


"FStuttgen" wrote in message
...
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?