Fixed table background Excel 2007

[Miss.Excel]

Hey everyone,

Really hoping I could get some help on this.

I'm just creating a staff database in Excel. Now I'm using a colored table as a background to keep the database clear. So all the rows are alternately colored.

The problem is that when I sort the database on 'location' for example, all the row colors go with it. So I have a messy database that shows 10 blue lines, then 25 dark blue lines, 5 blue lines, etc. In stead of keeping them alternately colored.

Is there any way I could sort the content of the cell, but not the actual cell color?

So all the row colors will stay in order, but the content changes?

Hope this all makes sense!

Looking forward to any suggestions!

Many thanks,
Miss.Excel

 

[VoG]

Try Conditional Formatting to colour the rows http://www.contextures.com/xlCondFormat03.html#Shade

 

[kidwispa]

I found this answer on another forum (not sure if I was allowed to link to it so have copied the answer directly)...

Use Conditional Formatting to shade every other row.....Here's how:

Select All cells (by clicking the empty gray box in the upper left)

Then....from the Excel Main Menu:
<format><conditional formatting>
Condition_1: Formula is: =MOD(ROW(),2)
Click the [Format] button and select a shade color....Click [OK]

Note:
=MOD(ROW(),2)........Shades Odd numbered rows
=MOD(ROW(),2)=0.....Shades Even numbered rows

 

[Miss.Excel]

Hey VoG and Kidwispa,

Thank you every so much for your quick replies!

That trick done it!! :D :D

Brilliant stuff!

Can't believe I have looked all over the net for ages, and here I get 2 useful replies within 5 MINUTES! Lol.

Thanks so much guys (})

Well happy!!

xx