Change Interior Color using Cell Value

I am trying to adjust a cell's color using RGB. I know how to force the color using the RGB in vba but is there a way to do it based on a cells value?


This is the code i am trying to write:

Sub test2()
Range("B3").Interior.Color = RGB((Range("C3").Value))
End Sub

The value of Range("C3") = "(112, 133, 119)" (without the quotes)

Originally Posted by PY_

I am trying to adjust a cell's color using RGB. I know how to force the color using the RGB in vba but is there a way to do it based on a cells value?


This is the code i am trying to write:

Sub test2()
Range("B3").Interior.Color = RGB((Range("C3").Value))
End Sub

The value of Range("C3") = "(112, 133, 119)" (without the quotes)

I believe the most simplest and easiest way that i have ever came across was conditional formatting.

Now Conditional Formatting may not be exactly what your looking for however you can make it format the cells however you want. And it saves you time in the long run.