Building Websites since 1998
Not long ago a friend rang me up. He had to put forward a presentation and just wanted to highlight alternate rows in an Excel spreadsheet so that the data could be seen better via a projection system he was going to use. When I told him how to do it his reply was, "Is that it"?
So I thought that I'd share this really simple tip to get you up and running with this in no time at all.
Step 1. Open up excel and highlight the rows that you wish to add the formula to. In this case we will format 5 rows.
Step 2. On the 'Home' tab click on 'Conditional Formatting'
Step 3. On the 'Options' screen that appears choose 'New Rule' from the list and then type in: =MOD(COLUMN(),2)=0 When you have done this go to the 'Format' option button
Step 4. This is where we are going to define the colour of the row.
Step 5. Click on 'OK' and then 'OK' again on the next screen. That's it. You're all done.
With a little styling this is a better example of the finished product.
I hope that this simple solution helps you out.