Excel 2007 : Conditional Format on matching ID's

[party4one]

Hello,

I am new to excel 2007 and have been trying to do the following for a few hours (without any luck).

I have 2 columns of data one containing an unique user ID and the other showing some user submitted data as shown below.

ID Data

48 forename 1
48 surname 1
48 Address 1
48 Comment 1
49 forename 2
49 surname 2
49 Address 2
49 Comment 2
50 forename 3
50 surname 3
50 Address 3
50 Comment 3


What i would like to do would be to either merge the 2 columns into single rows where the ID numbers match.

OR

Leave the structure the same and have alternative row(s) colour for each set of ID's so all the ID's that equal 48 will be red, all ID's that equal 49 will be blue ID's equal 50 will be red again and so on.

Many thanks in advance

[NBVC]

With the second option,

If you select from row2 downwards, the whole range.. then apply conditional Formatting|New Rule from the Home tab.

Select Use a formula to determine which cells to format... then insert:

=MOD(ROUNDUP(SUM(1/COUNTIF($A$1:$A1,$A$1:$A1)),0),2)=1

Assuming you are starting at A2....

Click format and choose colour from Fill tab

[party4one]

WOW, thanks a million for the fast / accurate reply, works like a charm.

Cheers