Conditional formatting again.

[CoolKid]

Hi everyone,

I am trying to format some data to make it easier for users to read. Basically I have extracted a report of duplicate files on our filesystem which looks something like the data below:

106205188 103 Mb File A
106205188 103 Mb d:\re-size\File A
103694340 101 Mb File B
103694340 101 Mb d:\re-size\File B
103694340 101 Mb d:\presentation\File B
103694340 101 Mb d:\temp\File B
98103835 95 Mb File C
98103835 95 Mb d:\re-size\File C

I want to colour File A with one colour, File B with another colour, and then File C with the same colour as File A and so on for a spreadsheet with 1000 rows plus. As above.

I have scoured the internet, and can find many examples of alternate rows, but not alternate rows based on equal values. If anyone can point me in the right direction it would be greatly apprecitaed.

[NBVC]

Try this website for some ideas:

http://www.mvps.org/dmcritchie/excel/condfmt.htm

Look for the title: Color Grouping with alternating colors (#grouping) in the top 3rd of the page