Is there a Script for changing colors based on r g b values in other cells

[remejiah]

Hi I am very new to using the script editor, but i need help getting a background color in column 4 based on the rgb values in columns A(r) B(g) and C(b). I would need it to change when those values change. is there any way to do this? here's a screenshot of what my sheets doc looks like.

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
The script runs when you enter a value in column A Or B Or C Manually

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  5/25/2021  10:39:27 PM  EDT
On Error GoTo M
If Target.Row > 1 And Target.Column < 4 Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Dim r As Long
r = Target.Row
Cells(r, 4).Interior.Color = RGB(Cells(r, 1), Cells(r, 2), Cells(r, 3))
End If
Exit Sub

M:
MsgBox "You may have entered a improper value in one of the cells" & vbNewLine & "You entered  " & Target.Value

End Sub