Report Generation Toolkit, Excel

[parissa_wall3]

I am writing an application that log the measurment data into an Excel file, I want to format the cells that have values above -0.000080 to blue , below -0.000120 to red and leave the values in between black. I used "Excel Set Cell format.vi and wired : [Red][<=-0.000120];[Blue][>-0.000080];

however when the code runs, the blue section works fine but the red format the cells to red but shoes them in positive and the cells with value in between are shown as ##########

[Munna232]

Please share your code.

[mikeporter]

The string octothorps means the column is too narrow to display the data with the specified formatting.

Mike...

[ben64]

---

@parissa_wall3 wrote:

I am writing an application that log the measurment data into an Excel file, I want to format the cells that have values above -0.000080 to blue , below -0.000120 to red and leave the values in between black. I used "Excel Set Cell format.vi and wired : [Red][<=-0.000120];[Blue][>-0.000080];

however when the code runs, the blue section works fine but the red format the cells to red but shoes them in positive and the cells with value in between are shown as ##########

---

You provided color format and conditions but no number format. You should also respect the usual order of format number strings: Positive;Negative;Zero;Text. In this particular case your blue section first, followed by the red section and then provide a zero case for the values in between.

Try this string:  [Blue][>-0.00008]General;[Red][<=-0.00012]-0.000000;[Black]General

Ben64