Microsoft Excel Magic : How to make colors automatically, using the R G B value?

[@neileyre6019]

Just in case anyone else makes the same mistake as I did, the x1Up should use a lower case L and not a 1as it seems to appear. Otherwise you'll get an error.
Many thanks to Ger Plante on the superb Ozgrid.com forum for the clarification

[@ruhtbellchoqueduenas209]

Thanks for your help, I had the same mistake

[@eg7029]

👍 thanks!

[@nestortorres1791]

Thanks¡¡¡

[@SirChickenMacNugget]

Thanks for this, and thanks to Neil Eyre in the comments for the fix of 1 to l, fixed it for me.

[@abhrakumar1129]

Is there any option to get RGB value in cells from fill colour?

[@ravishanker8539]

Hi David, nice video. Is it possible to convert a spectrum (reflactance/transmittance) into CIE/RGB values in excel?

[@ReesSorby22]

hello, if you want a worksheet for this let me know!

[@eg7029]

Wunderbar! thanks for sharing this !

[@zeeshansarfaraz8985]

How can i get sheet ?

[@love131424]

thank~ your video help me a lot ~

[@ansgenterprise5876]

hey, can you please send me the code ?

[@akss3638]

lastrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lastrow
R = Range(Cells(i, 1), Cells(i, 1)).Value
G = Range(Cells(i, 2), Cells(i, 2)).Value
B = Range(Cells(i, 3), Cells(i, 3)).Value
Range(Cells(i, 4), Cells(i, 4)).Interior.Color = RGB(R, G, B)
Next i

[@geoistalking]

you are cool=)))