Biff,

Thank you, I can make that work.

I was hoping not to have to have my child rows start in column B, but I can
see how my layout might have given you that impression. I've actually
indented the contents of each of the columns.

Is there some way to detect the level of a row within its grouping? Then
identifying the parent row would make the conditional formating
straightforward.

Thanks so much for your response!

"T. Valko" wrote:

Correction:

I'm assuming that the make is in one column and the models are in another
column (that's how I'm interpreting the offset in your posted sample)

Change the formula to:

=MOD(COUNTA($A$2:$A2),2)=1

Screencap:

http://img262.imageshack.us/img262/1954/cfzg7.jpg

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

Assuming your data starts in cell A2.

Select the range of cells in question
Goto the menu FormatConditional Formatting
Formula Is: =MOD(COUNTA(A$2:A2),2)=1
Click the format button
Set the fill color to a shade of gray
OK out

--
Biff
Microsoft Excel MVP


"Habanerotary" wrote in message
...
For readability, I would like to be able to band a spreadsheet that has
been
grouped. Either of the following solutions would work...

Ex:

Ford
Mustang
F-150
General Motors
Corvette
Silverado
Honda
S2000
Ridgeline
Element

1. (Preferred) Alternate grey (G) and white (W) background on rows at
level
1 and have all child rows inherit that background color.

(G) Ford
(G) Mustang
(G) F-150
(W)General Motors
(W) Corvette
(W) Silverado
(G)Honda
(G) S2000
(G) Ridgeline
(G) Element

2. (Acceptable) Set a grey background for all rows at level 1 and a white
background for all child rows.

(G) Ford
(W) Mustang
(W) F-150
(G)General Motors
(W) Corvette
(W) Silverado
(G)Honda
(W) S2000
(W) Ridgeline
(W) Element

Obviously, this involves Conditional Formatting, but how can I ask a row
if
it's group level or how can I band child rows to follow their parent row
when
the parent rows alternate background color?

Thanks!