Formatting Issue

Hi,

So I have a template that has a piece of formatting code which I obtained from a different post in this forum. It alternates gray & white on a copy of a pivot table to make it easier to read. Normally there are 5 different Sample Names per grouping but in this one example the user only had 3 so my formatting is off in the end. Would it be possible to get some help with this code to make it more dynamic. I would like that this modified piece of code can either get the number by input from the user or that it can get the number on its own (by maybe counting Vial rows or when there is a repeat in Sample Name) and create the correct formatting no matter how many the user may do? Please advise....

Thank you so much for your assistance.

I'm not sure I understand. Where do I put this code? Should it replace the formula I have there for calculating or add to it? Please advise....

OK now I understand and wanted to say that that CF Formula gets put there by MyFormat piece of code, that runs along with others when the user clicks on the button on the Paste Rentention Data Tab, I never put it there. I have gone in to that CF formula and changed it to what you indicated and then applied it but it's still off. So my next question is if the user presses the button to run all the macros again will it over ride that formula or will it create another? And which CF will then take precedence? Here is the file again with the CF formula changed to what you told me.

Thank you soo much, that did it and it's working great!