When you reference another cell through a formula formatting does not pass
through

So if B1 contains 10 and is yellow then A1 having
=B1 formula will get 10 but not the formatting.

"Brian D" 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.