I have a worksheet in Excel 2002. That worksheet has many rows of data. In column A of that data are 9 digit numbers. Often, there are two or three rows with the same 9 digit number. I have sorted the data from lowest to highest, so when the numbers are the same, they are one after the other. However, the report is hard to read. I'd like to somehow make is so there is a distinction between rows where the numbers differ. So, if the first 2 numbers match each other, then those rows could be white - and then the next 3 match each other and those 3 would be gray - and then the next two match either other and they would be white, etc. Alternatively, I'd be happy to insert a blank row whenever a new number shows up in sequence. Is there a way to do this?