Forum Discussion
How to color a cell based directly on a cell value
On mobile bc my internet isn't working today How do I color a cell based not on its statistical relationship with other cells, but directly on its value? In particular I have a series of RGB values...
It's three columns, one per channel. I also created a custom format, (##0);_(##0);_(##0) , which hopefully would work as well.
rekkandevar As I said, there are no workbook functions or out of the box ways to use numbers in cells to fill a cell with RGB colors. This would require VBA. Are you open to that?
rekkandevar Attached is a file with a ChangeEvent macro working on Sheet 1. When you enter numbers into columns A, B and C, the cell in column D of the same row will be filled with the respective RGB value. You can copy and paste multiple values at the same time. Empty cells are treated as zero. If the number combination results in invalid RGB, the cell fill will be removed and a warning displayed in the cell.
Is that something you can work with?