How to shade every third row?

[Guest]

Hi, this is probably a very simple question.

I use Excel for financial reporting and would like to make the presentation
of data clearer.

So, am wondering how do you highlight, say every third row in the report?

Pls help. Thks. ;-)

 

[Guest]

Go to this site and download utility add in. It will accomplish what you want
http://www.asap-utilities.com/
Pat F

 

[CLR]

This is one of many features in the ASAP Utilities Add-in,
free from www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3

 

[Jim Cone]

Or if you don't want 300 other utilities...
my Excel add-in "Shade Data Rows" shades by cell value
or by every Nth row.
Comes with a one page install / use Word.doc file.
Available free upon direct request.
Remove xxx from my email address.

Jim Cone
San Francisco, USA
(e-mail address removed)

 

[Guest]

Hi guys,

Thanks for the suggestions, but am wondering is it possible to do it
without any add-ins? Meaning, just by using Excel functions? ;-D

Thks again!

 

[Biff]

Hi!

Yes, it can be done with conditional formatting.

How do you want to apply this? Starting from where? Do you want the first
row to be shaded?

Biff

 

[Max]

Guess you could also try this play ..

Press CTRL+A to select the entire sheet
(or just select the target rows, say rows 1 to 21)

Click Format > Conditional Formatting
Under Condition 1, make the settings:
Formula is: =MOD(ROW(),3)=0
Click the Format button > Patterns tab > Light green? > OK
Click OK at the main dialog

 

[Max]

Formula is: =MOD(ROW(),3)=0

On separate sheets, try also tinkering with the other 2 possible settings
for the formula in condition1, viz., try instead:

=MOD(ROW(),3)=1
=MOD(ROW(),3)=2

to see the differences that changing the formula makes to the row shading

(Btw, I'm also using Jim's add-in .. )

 

[Guest]

Thank you so much! It works beautifully! ;-)

On separate sheets, try also tinkering with the other 2 possible settings
for the formula in condition1, viz., try instead:

=MOD(ROW(),3)=1
=MOD(ROW(),3)=2

to see the differences that changing the formula makes to the row shading

(Btw, I'm also using Jim's add-in .. )

 

[Max]

You're welcome !
Thanks for the feedback ..

 

[Dana DeLouis]

... but am wondering is it possible to do it

without any add-ins? Meaning, just by using Excel functions? ;-D

Just throwing this idea out. Select your data, and do Format | Auto Format,
and select something like "list1", or "list2." Maybe not exactly what you
want, but it may be close. :>)