VLOOKUP Help Needed

A

ACA Marketing

I am using the VLOOKUP function and it is bringing in the result that
want - however, it is not bringing in the text color from th
originating cell. (The text it is finding on the first spreadsheet i
blue but when the function returns the answer onto the secon
spreadsheet it is black every time.) Is there a way to retain the cel
formatting like colors or background patterns using VLOOKUP??? I am a
a loss. Thanks
 
A

ACA Marketing

So.... if I can't do that with VLOOKUP does anyone know how to make the
formatting of one cell flow into another using a formula??? By
formatting I do mean colors, backgrounds, font colors, etc. There will
be no value (in fact no entry at all) in the cell that I am referring
to. Assuming "1" means Green, "2" means Yellow, etc., if I enter "1"
in Col A Row 1, I want to have the formatting from a cell on another
spreadsheet flow into Col B Row 2 everytime "1" is entered in Col A. If
I put "2" in Col A, I want Col B's correct row and cell to be Yellow.
What I have is one spreadsheet with a number and color "key" on it and
want to use it to basically automatically fill in information in Cols
B, C, D that correlates with my "1" and "2" in Col A, etc. I have
succeeded with the cells on the key that contain values - using the
VLOOKUP as mentioned earlier - but have one cell on the key that simply
contains a background color. Anyone have any ideas??? Excel may not be
able to accomodate this request, but I just have to believe there is a
way!
 
B

Bob Phillips

There seems to be a contradiction in what you are saying (at least as I read
it ;-)). You say you want the format to be picked up from elsewhere, then
you say that if A1 =1 , you want it to be coloured green.

If you are going to codify it, by putting some value in A1, you could use
event code to trap that and do formatting based upon its value.

If you have firm rules it can be done I think.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ACA Marketing" <[email protected]>
wrote in message
news:[email protected]...
 
Top