RGB lookup

[chef]

I am wondering if there is an easy way to create a colour pallette using lookup to automatically display the RGB colour/shade

I have 3 columns in B,C & D and eg 138 in B1, 127 in C1 and 128 in D1 and in column E, I change the colour manually with the codes to see what shade that is ie grey

Is there a way I can type in various RGB codes in the column rows and have the colours and shades fill in each row in column D

many thanks

 

[Fluff]

You can do that with a macro like

Sub chef()
   Dim Cl As Range
   
   For Each Cl In Range("E2:E" & Range("D" & Rows.count).End(xlUp).Row)
      Cl.Interior.Color = RGB(Cl.Offset(, -3), Cl.Offset(, -2), Cl.Offset(, 1))
   Next Cl
End Sub

 

[chef]

wow...that worked a treat and genius.....thats so helpful and thanks for taking the time to do that as well appreciated.

 

[Fluff]

You're welcome & thanks for the feedback.