| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can RGB fill color be automated based on 3 cell values?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can RGB fill color be automated based on 3 cell values?
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can RGB fill color be automated based on 3 cell values?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing cells within a column based on cell fill color | New Users to Excel | |||
| Reference a cell based on Fill color? | Excel Discussion (Misc queries) | |||
| How do you fill a cell with a color based on IFTHEN formula? | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
Linear Mode
