I have a conditional format set up to change cells different colours
when certain conditions are met. I want to be able now to set up a
separate table with all the same coloured cells in. I'm sure this is
possible, however, I also want to be able to copy the row title into a
section of the new table. Is there a way to do this?