You wouldn't use conditional formatting in the lookup.

You'd try to mimic the colors of the original cell using conditional
formatting.

For instance:If that original cell only has 3 possible values, then you could
just check each of those values in the conditional formatting rules.

I would expect it to be a possible solution in a very small number of
situations.

Julie wrote:

I know how to use conditional formatting, but when doing a lookup. It's
important that I find an answer to this because it's a daily issue and time
consuming. Can you give me any hints about how to use conditional formatting
in a lookup?
--
Julie

"Dave Peterson" wrote:

Maybe you could use conditional formatting, but it's pretty limited when you
want to use it like this.

Julie wrote:

I have a simple lookup table that brings value in from a sheet of numbers,
some of which have a red font. Is there any way to bring in both the value
and the red font format?
--
Julie

--

Dave Peterson


--

Dave Peterson