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"
wrote in message
news:ACA.Marketing.1uchai_1125014738.0451@excelfor um-nospam.com...

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!


--
ACA Marketing
------------------------------------------------------------------------
ACA Marketing's Profile:
http://www.excelforum.com/member.php...o&userid=26652
View this thread: http://www.excelforum.com/showthread...hreadid=399261