How to remove color which provided using set range color activity

Hi,
I have an excel created using set range color… If data count is below 5,Green 5 and above color is orange. Based on that it is updating in the excel. I did this in Reframework If I want remove that color after first transaction. Can any one please help me how can i do that.

@Chippy_Kolot

You can then set the color to white again using set range color again

cheers

@Chippy_Kolot

Can you show how and what you tried

Did you try with format cells as well?

cheers

Ya it is working now…


But borders are coming like this…Can we do anything to keep borders…

@Chippy_Kolot

Instead if white try using transparent System.Drawing.Color.Transparent

cheers

Hi,

If you can use modern excel, can you try FormatCells activity with Transparent as the following?

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.