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