Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to shade every third row?
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. ;-) |
#2
|
|||
|
|||
Go to this site and download utility add in. It will accomplish what you want
http://www.asap-utilities.com/ Pat F "jy" wrote: 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. ;-) |
#3
|
|||
|
|||
This is one of many features in the ASAP Utilities Add-in,
free from www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "jy" wrote in message ... 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. ;-) |
#4
|
|||
|
|||
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 XX "jy" wrote in message ... 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. ;-) |
#5
|
|||
|
|||
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! "Jim Cone" wrote: 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 XX "jy" wrote in message ... 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. ;-) |
#6
|
|||
|
|||
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 "jy" wrote in message ... 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! "Jim Cone" wrote: 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 XX "jy" wrote in message ... 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. ;-) |
#7
|
|||
|
|||
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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "jy" wrote in message ... 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! |
#8
|
|||
|
|||
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 .. ) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#9
|
|||
|
|||
Thank you so much! It works beautifully! ;-)
"Max" wrote: 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 .. ) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#10
|
|||
|
|||
You're welcome !
Thanks for the feedback .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "jy" wrote in message ... Thank you so much! It works beautifully! ;-) |
#11
|
|||
|
|||
... 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. :) -- Dana DeLouis Win XP & Office 2003 "jy" wrote in message ... 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! "Jim Cone" wrote: 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 XX "jy" wrote in message ... 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. ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Let Excel shade every 3 line automatically | Excel Discussion (Misc queries) | |||
How do I shade the space between two data series in Excel? | Charts and Charting in Excel | |||
Template for graphing algebra inequalities and easy to shade the . | Charts and Charting in Excel | |||
How do I shade cells using the "IF" function? | Excel Worksheet Functions | |||
How to shade a row of cells using conditional formatting | Excel Worksheet Functions |