So, I've been trying to figure this one out for a while...
I have a column of data that has several different background colors assigned to each cell. For example, A2 is blue, A3 is orange, A4 through A10 is yellow, and then A11 is blue again.
I would like to copy and paste these background colors across all the rows in the spreadsheet; however, if I simply copy and paste special > formats, it also pastes the column width and other formatting options from column A that I do not wish to have changed on my spreadsheet.
I have done some research on this and I now know that each color is assigned a number and I can have the number returned using a function or a macro (I'm not really certain of the difference or if there even is one) and then use that value to then set the background color of each row accordingly.
The problem is that even after reading articles like this and this, I still can't seem to figure out how to put the information together to do what I want to do.
Can anyone interpret this for me and possibly produce a code that does what I am needing?
Thanks in advance!
-Amy Kate
Bookmarks