Finding RGB color code for conditionally formatted cells (VBA)

[mbk0523]

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

 

[NdNoviceHlp]

Maybe this will get U started...

[sheet1!A1].Interior.Color = RGB(255, 0, 0) 'red

HTH. Dave

 

[mbk0523]

Hi Dave,
Thanks for your response, but I'm not sure we're on the same page here...
I have conditionally formatted a range of cells with the "color scales" format, and I want to know the RGB code of each cell.
Does that make sense?

Thanks