Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Greenbar look

0 views
Skip to first unread message

Don Rountree

unread,
Feb 27, 2003, 10:34:38 AM2/27/03
to
How can I easily program my conditional formatting to
color every three rows leaving the next three uncolored
and then coloring the next three after that. I've seen
this formula in the past, but can't recreate it. Thanks
in advance.

Don Rountree

Don Guillett

unread,
Feb 27, 2003, 10:44:59 AM2/27/03
to
In conditional formatting>formula is
=mod(row(),3)=0

--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com
"Don Rountree" <do...@somersetfoods.com> wrote in message
news:03b201c2de75$bd031170$a001...@phx.gbl...

Gord Dibben

unread,
Feb 27, 2003, 12:19:46 PM2/27/03
to
Don

CF>Formula is =MOD(ROUND(ROW()/3,0),2)=0

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Thu, 27 Feb 2003 07:34:38 -0800, "Don Rountree" <do...@somersetfoods.com>
wrote:

Chip Pearson

unread,
Feb 27, 2003, 4:14:21 PM2/27/03
to
Don,

See www.cpearson.com/excel/banding.htm for an detailed explanation
to do exactly this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Don Rountree" <do...@somersetfoods.com> wrote in message
news:03b201c2de75$bd031170$a001...@phx.gbl...

0 new messages