If the font/cell colour in the source sheet is applied through
conditional formatting, then you could use the same settings to apply
to your cell with the lookup formula. If they are set manually,
though, then you will not be able to reproduce them in another sheet
using a formula - you would need some VBA code to do that.

Hope this helps.

Pete

On Jul 22, 3:44*pm, JPS wrote:
I am using a lookup function to pull data from one spreadsheet to another and
I need to retain the font/cell color from the source spreadsheet to the new
cell on the target spreadsheet.

Doable? *
JPS