Set background colour of cell to RGB value of data in cell

excel vba rgb
Internet man picture Internet man · Sep 15, 2009 · Viewed 259.5k times · Source

I have a column containing RGB values, e.g.:

127,187,199
67,22,94

In Excel, is there any way I can use this to set the background colour of the cell?

Answer

Galwegian picture Galwegian · Sep 15, 2009

You can use VBA - something like 

Range("A1:A6").Interior.Color = RGB(127,187,199)

Just pass in the cell value.

Related questions

Return RGB values from Range.Interior.Color (or any other Color Property)

I was trying to incrementally change the background color of a cell to black, and I found that the Range.Interior.Color method returns a Long which is seemingly arbitrary. Looking at the documentation on MSDN, there is nearly nothing …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More