Conditional Formatting to Uneven Merged Cells

Hello,

I have a large sheets with over 13000 rows which some of cells are merged (to indicate a group). Unfortunately, they have to stay merged
I want to fill every other group name (Column A in attached file) with alternating color.
I know that conditional formatting with the code;

Please Login or Register  to view this content.

does the job for unmerged cells (Column B in attached file).

So far I have managed to find this code

Please Login or Register  to view this content.

which allows me to alternate color of every 6 rows. (Most of my merged cells are 6 rows.) However, some group names are created by merging 7-10 rows.

How to write a conditional formatting for these uneven merged rows?

Hi,

You can try this:

=ISODD(COUNTA($A$2:A2))

Originally Posted by Phuocam

Hi,

You can try this:

=ISODD(COUNTA($A$2:A2))

Thank you, solved my problem