Excel Set Range Color

[caoshixiao]

Hi All,

I’m trying to set range color which I got from the ‘Get Cell Color’ Activity.

The output of the color is ‘Color [A=255, R=191, G=191, B=191]’

How can I add this color into the code: System.Drawing.Color.Fromargb()？

Thanks & Regards,

[AshwinS2 (Ashwin S)]

Hi @caoshixiao

Set the System.Drawing.Color in default value in variable pane

Print the value as color.Name.ToString

Thanks
Ashwin S

[caoshixiao]

Hi,

Thanks for the quick reply, but I’m getting some weird output: ‘ffbfbfbf’, Please Check if i put the right code into the Log Message, ‘Gray_Color’ would be the one I assigned in the ‘Get Cell Color’ Activity

[caoshixiao]

OK I figured out,

Simply use the assigned name in the ‘get Cell Color’ activity and paste it to the ‘set range color’ activity, that will work.

‘system.drawing.color’ isn’t required in the code.