Hello,
I am using Excel 2007.
I have a big spreadsheet that has been sorted by column A, which is a list of product types--the words can vary, so there are no set words I can give you.
I don't know how to write code, but I would like a VBA code that will highlight a table row (not an entire row) a certain pastel color for all products that have the same word in column A. When the word changes in column A to the next set of product types, then I want Excel to highlight these sets of rows a little darker version of the previous color. When the word changes in column A to yet another set of product types, I want Excel to highlight these sets of rows back to the original pastel color...and so on, so that the table rows are highlighted by product types, alternating btw. the two colors.
I couldn't find this anywhere. Can anyone help?
Thank you in advance for your help!
I am using Excel 2007.
I have a big spreadsheet that has been sorted by column A, which is a list of product types--the words can vary, so there are no set words I can give you.
I don't know how to write code, but I would like a VBA code that will highlight a table row (not an entire row) a certain pastel color for all products that have the same word in column A. When the word changes in column A to the next set of product types, then I want Excel to highlight these sets of rows a little darker version of the previous color. When the word changes in column A to yet another set of product types, I want Excel to highlight these sets of rows back to the original pastel color...and so on, so that the table rows are highlighted by product types, alternating btw. the two colors.
I couldn't find this anywhere. Can anyone help?
Thank you in advance for your help!