Conditionally formatting entire rows

[Paul Kraemer]

Hi,

I am using Excel 2007. I have a worksheet that has at least 10 columns and
many rows. I use the first column to allow me to "select" certain rows. If
I want to "select" a row, I enter an "x" in the first column. To leave a row
unselected, I leave the first column blank.

I would now like to change the fill color of all the cells in all the
selected rows. The conditional formatting feature makes it very easy to
change the formatting of cells in the first column that contain an "x". I
can't seem to figure out how to extend this so that if the first column in a
row contains an "x", I could change the fill color not just of the first cell
in that row, but also all the other cells in that row as well.

If anyone could tell me if this is possible and give me a clue how to do it,
I'd really appreciate it.

Thanks in advance,
Paul

 

[toni.gee]

Paul,

Probably the easiest way is to apply a simple filter (Autofilter) and select
only those cells in the first column with an "X". Then select the entire
filtered subset and apply your fill colour before removing the filter.

 

[Paul Kraemer]

Hi Bob,

Thanks for your response. Using the formula you suggested works perfectly,
but I can only seem to get it to work if I create a different conditional
formatting rule for each row, one row at a time. In other words, creating
the following rules one row at a time works:

Row 1 rule =$B1="x"
Row 2 rule = $B2="x"
....
Row N rule = $BN="x"

I was wondering, is there any way I can select all rows and create just one
rule that can apply to all rows? If not, is there a way that after creating
a working rule for one row, can I copy it somehow and paste it onto the rest
of the rows (with the row number reference in the rule adjusting
automatically for each row)?

Thanks again for your help,
Paul