Jump to content
NickC

How to change cell color in Excel programmatically.

Recommended Posts

How to change the cell color in Excel programmatically depends on the result(Pass, Fail and Not tested).

 

I am generating report with signal name, value and the result and result are 3 different states(Pass, Fail, Not Tested).

 

Each state should have one color.

 

Can anyone suggest how do it?

Share this post


Link to post
Share on other sites

The simplest way would be to utilize the report generation toolkit and populate a template.  In your template you can have coloring rules based on the values you anticipate putting in those cells.  Basically set it all up in Excel first and just fill in the data with LabVIEW.

Share this post


Link to post
Share on other sites

Thank you Jordan, Is there any perfect example.

 

Is there any way by using Excel set color and border vi, With this I am able to change the border color but not cell color.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.