Format cell alternating automatically by given value

[lilloscar]

I can do this by giving a formula en every value (image 1), but I need to do only with one formula (image 2) alternating every two given values because there will be more tan 100 files that I need to do the same , may be I need a helper column...

 

[Tetra201]

... may be I need a helper column...

Here is how you can set up a helper column:

Let's assume your data is in range C4:C###, and column Z is your helper column.
Then, enter 1 in cell Z4, put the following formula in cell Z5, and copy it down:

=IF(C5=C4,Z4,-Z4)

Now you can CF cells in column C based on the value of their counterparts in column Z.

 

[lilloscar]

Here is how you can set up a helper column:

Let's assume your data is in range C4:C###, and column Z is your helper column.
Then, enter 1 in cell Z4, put the following formula in cell Z5, and copy it down:

=IF(C5=C4,Z4,-Z4)

Now you can CF cells in column C based on the value of their counterparts in column Z.

Thank
you again I will give a try, I just founded this answer, seems to work only with only one color, am trying to find to work with second row color
http://www.mrexcel.com/forum/excel-...hen-first-column-data-change.html#post3456287

 

[lilloscar]

Just to complete the post, I solved this way my problem:

<code>=MOD(SUM(1/COUNTIF($C$4:$C4,$C$4:$C4)),2)=1

=MOD(SUM(1/COUNTIF($C$4:$C4,$C$4:$C4)),2)<1</code>

Thanks @Tetra201

 

[Tetra201]

You are welcome.