Prev: Fill Series
Next: Unique Random Numbers
From: Jaclyn on 10 Feb 2010 00:05
Is there any way to automatically adjust the fill color of a cell based on 3
values entered into 3 cells?

Specifically, if I have entered the values 100, 120, and 50 into cells A1,
A2, and A3, respectively, is there a way to automatically fill cell A4 with
the RGB color Red=100, Green=120, Blue=50?
From: מיכאל (מיקי) אבידן on 10 Feb 2010 04:37
Maybe: [A4].Interior.Color = Evaluate(RGB([A1], [A2], [A3]))
Micky


"Jaclyn" wrote:

> Is there any way to automatically adjust the fill color of a cell based on 3
> values entered into 3 cells?
>
> Specifically, if I have entered the values 100, 120, and 50 into cells A1,
> A2, and A3, respectively, is there a way to automatically fill cell A4 with
> the RGB color Red=100, Green=120, Blue=50?
From: Phil Hibbs on 10 Feb 2010 06:17
micky wrote:
> Maybe: [A4].Interior.Color = Evaluate(RGB([A1], [A2], [A3]))
> Micky

You'd have to put that in a Worksheet_Change macro.

Phil Hibbs.
 | 
Pages: 1
Prev: Fill Series
Next: Unique Random Numbers