Different approach? Re: Fill color based on RGB (PeterT?)

[ADK]

Peter,

The routine places a value in the cells of column D (under the shape). If I
transfer those
numbers to a different sheet, what would the routine be if using those
numbers
rather than the RGB values in columns A,B & C? ...the numbers would be in
column F of this new sheet

Thanks

ADK

Er, OK.

As it happens the routine I posted was written in Excell 2000.

Not sure what you are trying to convey.

Regards,
Peter T

 

[Peter T]

See my follow-up in your original thread.

Normally it's best to continue in the same thread, rather than starting a
new thread merely to continue the same topic. I only saw this message by
chance.

From the additional information you provided below it appears your
colour-values will be in col-F on some sheet, so in the new routine I posted
(in the original thread) change "G2" to "F2" or whatever the first cell is.

Regards,
Peter T

 

[ADK]

Thanks

See my follow-up in your original thread.

Normally it's best to continue in the same thread, rather than starting a
new thread merely to continue the same topic. I only saw this message by
chance.

From the additional information you provided below it appears your
colour-values will be in col-F on some sheet, so in the new routine I
posted
(in the original thread) change "G2" to "F2" or whatever the first cell
is.

Regards,
Peter T