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


--
Paul Kraemer