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!