<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style>I am reaching out to you guys because I have no experience with VBA but I do believe my problem can be solved through VBA.
Looking to the below spreadsheet, you can see that the cells in the data area are color coded. Columns F2:H2 will act as keys when filtering the data. Basically, I need a macro that starts at one of these key columns, checks each row if there is ANY cell that matches the color in the key column you’re on and if true, fills the background color of the cell in the corresponding evaluated row and key column, if false, leave blank. An example of the end result of the macro is shown in the image.
Using these key columns we can filter for every row that has any cell with that background color. When filtering, it’s completely fine that other colors get pulled in depending on the row, we just have to make sure all of the data for the color being filtered gets captured.
I’d be happy to provide additional clarification if needed. I’d appreciate any help on this as it would be a huge time saver for us but I have no experience with VBA.
Thanks!
Looking to the below spreadsheet, you can see that the cells in the data area are color coded. Columns F2:H2 will act as keys when filtering the data. Basically, I need a macro that starts at one of these key columns, checks each row if there is ANY cell that matches the color in the key column you’re on and if true, fills the background color of the cell in the corresponding evaluated row and key column, if false, leave blank. An example of the end result of the macro is shown in the image.
Using these key columns we can filter for every row that has any cell with that background color. When filtering, it’s completely fine that other colors get pulled in depending on the row, we just have to make sure all of the data for the color being filtered gets captured.
I’d be happy to provide additional clarification if needed. I’d appreciate any help on this as it would be a huge time saver for us but I have no experience with VBA.
Thanks!