If I am referencing a cell from one sheet to another, how can I get the formatting to follow. If the font is red on sheet 1, I need it to be red on Sheet 2 when the function calls for it. Any help?