NickC Posted March 13, 2015 Report Share Posted March 13, 2015 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? Quote Link to comment
Jordan Kuehn Posted March 14, 2015 Report Share Posted March 14, 2015 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. Quote Link to comment
NickC Posted March 14, 2015 Author Report Share Posted March 14, 2015 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. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.