Hi,
(Note: I am using Excel 2007).
I have a big range of cells on 'Sheet 1' that I have conditionally formatted. On 'Sheet 2' I have a table with the same column and row names as 'Sheet 1', but no data. In this table on 'Sheet 2' I want to put the RGB color (if possible in format RRR, GGG, BBB).
Hoping someone can help me with the VBA code to do this!
I found a lot of code already written on various websites, but they always returned the color index, and I need the RGB code. Or, in the case of this: Conditional Formatting Colors I keep getting a #VALUE! error whenever I try any of the code's formulas.
Thanks,
Matt
(Note: I am using Excel 2007).
I have a big range of cells on 'Sheet 1' that I have conditionally formatted. On 'Sheet 2' I have a table with the same column and row names as 'Sheet 1', but no data. In this table on 'Sheet 2' I want to put the RGB color (if possible in format RRR, GGG, BBB).
Hoping someone can help me with the VBA code to do this!
I found a lot of code already written on various websites, but they always returned the color index, and I need the RGB code. Or, in the case of this: Conditional Formatting Colors I keep getting a #VALUE! error whenever I try any of the code's formulas.
Thanks,
Matt