number format (conditioning) in excel set cell format vi

[Mukesh1980]

I am having data which is ranging between from -0.9999 to 0.9999 and want to set the color 'red'  when data value is more the -0.0750 or +0.0750 and 'Blue' color when data is in between -0.0750 to 0.0750.  I am using excel set cell format.vi then what should be number format.

Thanks

[suhasbr96 · Accepted solution]

Hi Mukesh,

Most of the excel cell formatting requirements can be met by altering the example VI : Report - Conditionally Formatted Spreadsheet.vi. Alternatively, you can use the ActiveX interface in LabVIEW for MS Excel to achieve the desired functionality.

For your requirement, you might have to call Conditional Formatting option within MS Excel through LabVIEW ActiveX interface and provide it with appropriate inputs.

Please go through this article for further details - https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000001DnMbCAK&l=en-IN

Regards

Suhas BR

[suhasbr96]

Hi Mukesh,

Most of the excel cell formatting requirements can be met by altering the example VI : Report - Conditionally Formatted Spreadsheet.vi. Alternatively, you can use the ActiveX interface in LabVIEW for MS Excel to achieve the desired functionality.

For your requirement, you might have to call Conditional Formatting option within MS Excel through LabVIEW ActiveX interface and provide it with appropriate inputs.

Please go through this article for further details - https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000001DnMbCAK&l=en-IN

Regards

Suhas BR