Keep formatting with lookup table

[Guest]

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?

 

[Dave Peterson]

Formulas don't bring back that kind of formatting.

 

[Dave Peterson]

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

 

[Guest]

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?

 

[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.

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?

 

[Guest]

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,

 

[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.)

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,