Hey all,
I want to take a color of cell and use that color to fill a range of corresponding cells in the same row as the cell fill color. I have already done conditional formatting to get a list of cells to be a bunch of different filled colors, but I'd now like to take each color and extend it to the rest of the table and highlight each line with the corresponding color.
I've done some googling but can't seem to find anyone else with the same exact problem.
Example:
E4:E77 is my list of already color coordinated items, and they are mixed around and there are duplicates, etc. I want to take those colors and "paste" them onto the corresponding rows in the remaining cells of the table, values F4:M77. If I try to use format painter, it does not work and instead ruins all formatting for the numbers and gives the wrong coloring.
It's probably very easy (and it should be) and I'm doing it in an overly-complicated way, but I can't figure out how to do it.
Thank you for any help!
Bookmarks