Formula for Automatically Colouring your Rows in Excel.

Posted on December 14, 2007 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

And we are closing this week with another Cool and Handy Excel Tip and Trick. Microsoft Excel shouldn’t be used only for “boring” formulas but your spreadsheet needs to look good too.

 

I presume that you all know that you can colour the cells of your spreadsheet so I’m not getting in to that. Now I want to show you a way that you can automatically colour the rows of your Excel Spreadsheet.

 

For automatically colouring your rows in Excel you’ll need to take the following steps.

 

We are now creating a formula to have Excel auto fill every third row.

  • Select rows the first 20 rows
  • Click on Conditional Formatting

 

Auto fill row

 

  • Select New Rule
  • And now select Use a formula to determine which cells to format
  • And enter the following formula =MOD(ROW();3)=0

 

Auto fill row

 

 

 

 

 

 

 

 

 

 

 

 

  • Now click on the Format button
  • And select your colour from the fill tab
  • Click OK
  • And Click OK in the formatting Window and your done.

 

Auto-fill-row-pic3

 

I hope you liked this Excel Colouring Trick.

Have fun this weekend and ill talk to you all on Monday, see you!!

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

2 Responses to “Formula for Automatically Colouring your Rows in Excel.”

  1. Trainee Trader on December 19th, 2007 11:26 am

    I came across the blog via Entrecard. I really like the modifications you have done with Brian’s theme. Some very handy tips and tricks.

  2. Vincent on December 19th, 2007 1:02 pm

    He thanks! The Entrecards are pretty cool. I’ve been browsing around on your site last week for quite some time. This was when I accepted your card on my blog. I’m reading a lot about forex these days. I planned to do more with it in the New Year when these busy days are passed. I also liked your currency rate widget. I’m looking for something like that for on another business blog of mine.

    If you are modifying your theme and you can’t get it to work just let me know, maybe I can help. I’ve tested a lot of things on my test blog. There will some additional changes coming in January; they will make this theme a lot more “playful and happier”. Unfortunately now with Christmas we are so busy on our blogs and blognetwork, pfff. So I don’t have any time to implement them directly.

    Anyway, talk to you soon and thanks for dropping your card.

Leave a Reply