format as table conditional

[donniedorian]

Hello,
I need conditional formating a column with banded rows , condition is band the rows with the same content the same, and the next one blank color

so I can see better where the rows with different differ

 

[bobsan42]

Insert a new column in which you can put a check and come up with a number - then use this number for conditional formatting
e.g. let's say you data is in column A, I also assume you have a Header row (insert 1 if you don't have)
then in B2 put this formula and fill down as long as needed:

=MOD(IF(A2=A1,B1,B1+1),2)

Select the range to format and use this formula for Conditional formatting:

=$B2=1

 

[donniedorian]

Thank you very much Bobsan

 

[donniedorian]

I have to come back to this solution which works, but is there a way to put in a macro