Dear all,

I'm using vlookup,hlookup and lookup function to show reference cells
in Excel, but I find the format of cells can't be shown, for instance,
color of cell. Is there any way (function or program) to realize this?

For example, in one cell of table, I input '10' then make font color
in red, fill color in blue. When I use lookup function to find '10',
the result only show '10' but font color and fill color are normal
instead of different color.

Thanks in advance.

jiang