how to show reference cell with color and other formats in Excel, help

[jiang]

Dear all,

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

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

 

[Herbert Seidenberg]

1. Select the LOOKUP result '10'
2. EDIT | FIND | 10 | FIND NEXT
3. EDIT | COPY
4. FIND NEXT
5. EDIT | PASTE SPECIAL | FORMAT
6. Close FIND window
7. ESC

Once you get this working, record it as a macro.
Edit macro. Instead of "10", type SELECTION.
To format any LOOKUP result, select it and run the macro.