Excel Set Color and Border VI: no fill?

[jyang72211]

If i use Excel Set Color and Border VI to modify the format of a cell, i will get white as my default color for my cell.  However, I am looking for no fill.  I don't want any color, since the color will hide the gird line.  What do I get the no fill option for cell color in LabVIEW?

[PiDi]

Connecting transparent color to "background color" input doesn't help?

[jyang72211]

 No, if I use transparent, black would show up.

[jyang72211 · Accepted solution]

I got it.  I just need to change the function by adding the pattern property and set it to -4142, which is no fill. 

[ben64]

I have to say I was waiting for this question (I have tried it and observed the same thing). The only solution I see is to use a combination of the RGT vis and ActiveX.

Ben64

note, I have connected Cell1 and Cell2 of the _Worksheet Range method but it is probably sufficient to connect only Cell1 here.

edit: Good, your solution seems a lot more simple!

[PsyenceFact]

Sorry to revive a slightly old thread.

I was also having the same problem, wanting to set the cell background to No Color, and I also came across the proposed solution of using the value -4142 to achieve this.  However, it doesn't seem to work for me!

Can I just confirm the version of Excel that you use please (I'm stuck with 2002 SP3), and also check that all you are doing is wiring a signed integer to the background color input of the Excel Set Cell Color And Border.vi?

Many thanks,

Andy