If the source cell is formatted yellow due to Conditional Formatting, you
could use the same CF on the target cell.


Gord Dibben MS Excel MVP

On Fri, 14 Nov 2008 15:17:00 -0800, Brian D <Brian
wrote:

Im trying to reference a cell's content including it's format in a different
cell. I cannot seem to figure out how to reference a cell format or its
color. Example: I have a cell with a number and the cell is yellow. I
refernce this cell on another sheet within the workbook and I can see the
number but the cell is white not yellow.