Using color in lookup
 

Here is my problem. I have data which I use lookup to search and that part
works fine however the data is colored in various colors, and the results
are always in black. Is there a way to get the results displayed in the
color of the data?

Thanks for the help.

Dave W

No, a formula cannot copy over a colour of another cell, if they are
coloured by a reason as opposed design you can use conditional formatting
and the same criteria you are using when selecting the colour

--
Regards,

Peo Sjoblom

(No private emails please)


"lugnut" wrote in message
...
Here is my problem. I have data which I use lookup to search and that part
works fine however the data is colored in various colors, and the results
are always in black. Is there a way to get the results displayed in the
color of the data?

Thanks for the help.

Dave W