I would like a macro to automatically (when run) color rows in a range where it begins at $A$3 to $T (the last row will change regularly) based on a text value in column E. The two text values are "CP" and "LG" and I would like to give the "CP" row a color index of 35 and the "LG" rows a color index of 37. I would only like the row to be colored up to the last column in the range "T". Thanks in advance.
I've managed to do it with:
However I would like to have the rows alternate between the color index and white and also avoid formatting the headings row as default which is in row 2. Any ideas?
Please Login or Register to view this content.
Not sure if this is what you mean, but you just want to skip rows then change:
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks