I am currently working with scorecards, and trying to compile data values and conditional formating (colour) into another worksheet using the offset function.

For example, when a cell is found, i need to get the value of this cell and the particular colour of this cell and past them both into a cell in a different worksheet, but in the same file.

So far, i've managed to get the value of the cell but not the colour. Is there a way to do that? cheers

fantoun