Is it possible to highlight a group of records in an alternating color scheme?

[itsjustjer]

EDIT: I'm kind of an idiot lol. I don't really need to have two different colors, just one color and the other can be left white. Any way to quickly differentiate is really what I'm after.

Hello, sorry for the vague title. I'm not quite sure how to concisely say what it is I need to accomplish.

I have a list with Customer IDs on it. Some Customer IDs have multiple lines on the list and others only have one line, it's just kind of random. I'm going to have to do some manual work based off of this list so it would be much easier if I can highlight the group of Customer IDs that belong together. It's just difficult because one Customer ID could have 5 lines and another only has 1. This will be something I do on a regular basis with a new list of Customer IDs every week. The spreadsheet has a ton of columns so it's not feasible to keep the Customer ID up on the screen at all times while I'm looking at other things.

I've tried doing this with formulas to check if the cell below or above is the same and if so giving an adjacent cell a value of True or False, then using Conditional Formatting to make all True cells a certain color and all False cells a certain color, but I can't quite seem to get it right. Any help would be greatly appreciated!

Here's an example of what I'm trying to accomplish, hope this makes sense!

Customer ID
111
111
222
222
333
444
444
555
555
555
666

[CK76]

If it's based on ID that's numeric only. Yes. You'll just have to use conditional format, for evens and odds.

For Even:
=Even(A2)=A2

For Odd:
=Odd(A2)=A2

[itsjustjer]

I see what you're saying. I apologize for my bad example. The Customer IDs are always numeric only, but they aren't always perfectly aligned like in my example. Sometimes we get a list and when we sort the Customer ID by smallest to largest, the Customer IDs will be missing numbers. So it may look like 111 and then 333 meaning there are two odd numbers next to each other in the list.

[CK76]

Ah ok then.

You'd need helper column. This will work for text as well as numeric.
In B1 enter 0 (or keep it blank).
In B2: =IF(A2=A1,B1,B1+1)
Copy down.

Then change CF formula to... (still selecting A2:A12 range).
=ODD(B2)=B2
And
=EVEN(B2)=B2

0.JPG

[itsjustjer]

Oh, that's awesome! It worked perfectly! I have one other question if you don't mind. Is there a way to expand the highlighting so it will highlight other cells in the row as well? For example, say the spreadsheet has data in column C and D, can the same highlighting color scheme be applied to other cells in the same row?

[CK76]

Just change the selected range and change formula to lock the column (Ex: =ODD($B2)=$B2)

[itsjustjer]

Excellent, this is exactly what I needed. You're awesome, thanks so much for your help!

[CK76]

You are welcome

If you are satisfied with the solution, please mark the thread as solved using thread tool found at top of your initial post.