Apply conditional formatting to the cells A:J. Here's how:
http://www.officearticles.com/excel/...ft_ excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Xavier" wrote in message
oups.com...
Hi Guys,

I was wondering if any of you would know how to do this using a macro.
I have data on an excel sheet that looks like follows:

1: A
2: A
3: A
4: B
5: C
6: C

What I want to be able to do is Fill Color the 3 rows with 'A' yellow,
the 1 row with 'B' white, and the 2 rows with 'C' yellow and so on. The
data spans between columns A-J (which means I would need to Fill Color
A1:J3 yellow for example). Does anyone know of a macro that would be
able to do this? Thank you for all your help!

Xavier