Hello,
I have a sheet containing different itemized lists of set items. This is automatically color coded based on data validation combined with conditional formatting. There are three separate tabs here (Necro 1, Necro 2, Barb 1). Each tab has 2 lists ie. Necro1 A and Necro1B
These sheets then output to a consolidated list showing all of the elements in the other lists in this fashion:
Rows:
Necro1A
Necro1B
Necro2A
etc.
Columns: Item 1, Item 2, Item 3 etc.
The issue I am having is taking the cell color (from conditional formatting) on sheets 1-3 and having it output on sheet 4.
I have tried to resolve this using vba but can't get it to work using Interior.Color
The only method that has worked is incredibly tedious. It applies the same conditional formatting to each cell (as they are all unique) as in the original sheets by checking the value of the original cell vs the drop down list values.
This results in 4 separate formulas per cell for 6 lists with 16 items. Can anyone help me simplify this so I don't have to do conditional formatting 384 times?
I have attached the file, you can see the conditional formatting solution approach I took in the Keep sheet A2 and B2. If input is changed in Necro 1 C2 and C3 the color does change. Just hoping for an easier method.
Bookmarks