Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a way to set value based on fill color of a cell
I am looking to set a numerical value of one cell based on the fill color of
another cell. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a way to set value based on fill color of a cell
in a macro?
if the fill color is the actuall background color and not produced by conditional formatting select Case Range("A1").Interior.ColorIndex case xlNone c = 6 case 3 c = 12 case 5 c=21 End Select Range("B9").Value = c -- Regards, Tom Ogilvy "banderson" wrote in message ... I am looking to set a numerical value of one cell based on the fill color of another cell. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can RGB fill color be automated based on 3 cell values? | Excel Discussion (Misc queries) | |||
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) |