fill a cell with RGB code

[cmendes]

Hello everyone,

Is it possible to have a set of three cells with the code for RGB followed by the corresponding color? Is there a formula for this?
For example have 238 then 113 then 25= orange cell
Thanks
C

 

[BarCodeWiz]

How's this?

Range("D1").Interior.Color = RGB(Range("A1"), Range("B1"), Range("C1"))

 

[cmendes]

hmmm...no....
i had the R G and B values on A1 B1 and C1 and I copy/pasted the formula you gave me on D1 and I only got the text of the formula...

 

[BarCodeWiz]

That's VBA code. Here's a quick example how you can use it:

To add this code, hit Alt+F11, double click on Sheet1, and copy/paste it into the editor.

Private Sub Worksheet_Change(ByVal Target As Range)
Range("D1").Interior.Color = RGB(Range("A1"), Range("B1"), Range("C1"))
End Sub