Jump to content

How to change cell color in Excel programmatically.


Recommended Posts

Posted

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?

Posted

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.

Posted

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.

Join the conversation

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

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
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.