Paint cell if data change

[mkvassh]

I have a table with data where I want to paint the cell each time there is a new number. Data is sorted.

See example.

1 - Color A
1 - Color A
1 - Color A
2 - Color B
2 - Color B
3 - Color A
3 - Color A
3 - Color A
4 - Color B
5 - Color A

I know Excel VBA, but is looking for some logic to recognize each time there is a number.

[Vraag en antwoord]

Take a look at the MOD() function in combination with conditional formatting. You can also place a sample file.

[AliGW]

Based on your very minimal sample data, you could create tow rules, one using ISODD and the other ISEVEN.

There are instructions at the top of the page explaining how to attach your sample workbook.

[mkvassh]

The numbers repeat themselves irregularily, like shown in the example. Sometimes not at all, one time, two times etc. It can also be any type of number between 1 and 1.000.000. I thought MOD, ISODD, ISEVEN is looking for a fixed pattern.

See attached example with an "As Is" - sheet and "To Be" - sheet

[AliGW]

My suggestion was based on what you showed us in the opening post. That's nothing like what you have now shared with us. I'll have another think.

[mkvassh]

Sorry if I was unclear on this AliGW. Appreciate any help.

[tanasedn]

No VBA need, just Conditional Formatting with a helper column
In B2

Please Login or Register  to view this content.

and format conditional with ISODD or ISEVEN
or this:

[AliGW]

Yes, very easy with a helper column!

If that is OK, I'll stop working on this - I was looking for an all-in-one solution with no helper column.

[mkvassh]

Thank you all. Much appreciated. Problem solved.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.