[Solved] Set Cell Color based on RGB values in a cell

NEED: To set the color of a cell based on an RGB value that is calculated by that cell, or perhaps another cell.
Conditional formatting isn't useful as I'd have to have a million styles (and I am aware of some of the hacks to get around the CF limit of 3...) The problem isn't the CF limit, the problem is that CF uses styles, and does not allow you to directly set the RGB values of a cell (from what I can tell, or am I missing something???)
STYLE() also requires that you have a style set.
What I need to do ideally is:
Cell A1 contains hex value #5500BB and the background is thus purple. When I change the cell to #00FF00 it becomes green.
------
My assumption at this point is that I have to write something. What I'd like most to create is just a function:
Either an 8bit: RGB( 123 ; 80 ; 255 ) or HEX: RGB( AA ; E0 ; 12 ) or decimal: RGB( 0.76 ; 0.05 ; 0.68 ) or maybe all with a selector: RGB( AA ; E0 ; 12 ; H )
Before I start trying to write this I thought I should ask if there is a method I am missing that already does this, and can I even change the cell color directly with a macro?
Conditional formatting isn't useful as I'd have to have a million styles (and I am aware of some of the hacks to get around the CF limit of 3...) The problem isn't the CF limit, the problem is that CF uses styles, and does not allow you to directly set the RGB values of a cell (from what I can tell, or am I missing something???)
STYLE() also requires that you have a style set.
What I need to do ideally is:
Cell A1 contains hex value #5500BB and the background is thus purple. When I change the cell to #00FF00 it becomes green.
------
My assumption at this point is that I have to write something. What I'd like most to create is just a function:
Either an 8bit: RGB( 123 ; 80 ; 255 ) or HEX: RGB( AA ; E0 ; 12 ) or decimal: RGB( 0.76 ; 0.05 ; 0.68 ) or maybe all with a selector: RGB( AA ; E0 ; 12 ; H )
Before I start trying to write this I thought I should ask if there is a method I am missing that already does this, and can I even change the cell color directly with a macro?