How would you take the specific conditional format of a cell and display that same color in a different cell in the same workbook. For instance, you've got a table that contains numbers and a correlated table containing percentages. The conditional format has been accurately reflected in the table containing the percentages, but you want the same color format in the table displaying the numbers. I'm attaching a file to help.
You'll notice that if I just do a copy and paste of the formatting from the bottom table to the top in week 2, the colors are not the same as those in the bottom. I want the cells in the top table to have the same colors as those in the bottom.
Bookmarks