How to add color to cells from a table

[adelagza]

Hi, I have this problem, I have an small Table with some numbers on the first column and some text on the second column, the numbers on the list are not in sequence as you can see the table enclosed, what I want is first to use a formula of the Lookup type and place the text in whatever cell I want, I guess that's easy with a formula like this "=LOOKUPV(A1,B1:C14,2,0)" considering that the table is on the Range "B1:C14" then once this is done I want to color the cell with the color the table has and that I know is with a "Conditional Format" and I have tried several with no success, can someone there could help me in order to finish this problem? Thanks in advance for your effort and I will follow your replies to try'em . ADELAGZA


[TABLE="class: outer_border, width: 200, align: left"]
<tbody>[TR]
[TD="align: center"]ECT[/TD]
[TD="align: center"]COLOR[/TD]
[/TR]
[TR]
[TD="align: center"]23
[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]55[/TD]
[TD="align: center"]CORR. SENCILLO[/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
[TR]
[TD="align: center"]51[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
[TR]
[TD="align: center"]61[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
[TR]
[TD="align: center"]71[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
[TR]
[TD="align: center"]82[/TD]
[TD="align: center"]CORR. DOBLE[/TD]
[/TR]
</tbody>[/TABLE]

I have placed the text in color, because I do not knew how to color the cells in the table, but actually what I want is that the cell be colored with the color of the
table text color and also where I choose to put the text elsewhere in the program that the text would be in black and the cell in the color according to
the number selected in the formula from the column "ECT"​

 

[SpillerBD]

You can copy and paste special\Formats to get that conditional formatting to another cell or range. However there may some issues with any relative referencing in the Conditional formatting.

 

[adelagza]

SpillerBD, thanks for your reply, actually what I want is some kind of formula and perhaps some conditional formating that once it is placed it can work by itself whatever time the program is used and variables are changed, I hope I can explained myself I am not very expert in the handling of Excel, but I want to learn as much as I can I am 86 years old but I consider that never is late to learn, and as you say, if you think that it can be done is half the battle!!

 

[adelagza]

SpillerBD, please see my message that I placed as a reply to my own question (I dont even learn how to handle myself in the Forum, yet, I hope I will learn as I use it!! - Thanks - Agustin

P.S. By the way on the table I sent first there are only two colors I need one for "CORR SENCILLO" and another for "CORR. DOBLE", i do not know How black became mixed the one color is for number 23 to 55 and the other color would be for number 42 to 82, hope I explained very clearly, it is not easy to write in a language it is not your own!! - Thanks