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

Formulas don't bring back that kind of formatting.

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

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

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

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

I appreciate your trying to help. I think I must be out of luck. Basically,
my lookup table changes every day. I cut and paste it from a Volvo order
status system. In their system, if a slot date for manufacture has changed,
they make the date red, so the color has nothing to do with a value. When I
cut and paste it into my table, the number stays red, but when I run my
lookup, the date that draws into my report does not stay red.

I'll have to figure another way to do this. Thanks again,
--
Julie


"Dave Peterson" wrote:

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

I would do my best to add a column to that table--an indicator to tell if that
date changed. Working with colors is gonna be a pain. (Try counting all the
dates that are red, for example.)

Julie wrote:

I appreciate your trying to help. I think I must be out of luck. Basically,
my lookup table changes every day. I cut and paste it from a Volvo order
status system. In their system, if a slot date for manufacture has changed,
they make the date red, so the color has nothing to do with a value. When I
cut and paste it into my table, the number stays red, but when I run my
lookup, the date that draws into my report does not stay red.

I'll have to figure another way to do this. Thanks again,
--
Julie

"Dave Peterson" wrote:

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


--

Dave Peterson