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
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.
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
Feb 27, 2003, 10:44:59 AM2/27/03
to
In conditional formatting>formula is
=mod(row(),3)=0
=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
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
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