Home Getting Started Help Guides Troubleshooting

    Why is the MeasurementXpert Color Formatting not exporting to my Excel report?

    My Excel report does not show red, yellow, or green as it does in my InspectionXpert.

    March 15th, 2019

    This article discusses what steps to take if the Pass (green), Marginal (yellow), Fail (red) color from the MeasurementXpert Table does not transfer to your Excel report when you publish.

    Step-by-Step Guide:

    1. Select the 'Home' tab
    2. Select 'Options'
    3. Go to 'Application Options'
    4. Select 'MeasurementXpert
    5. Under 'Export' select 'Apply Color to Cell Fill'
    6. Select 'Apply
    7. Select 'OK'

    Here is an example of the output of the 'MeasurementXpert' results in your Excel report.

    Note: If the Excel report template contains 'Conditional Formatting' in the measurement column the 'Conditional Formatting' will be applied. We recommend that you remove the 'Conditional Formatting' within Excel for your measurement columns before attempting to use the template with MeasurementXpert (see the screenshot below).

    Was this article helpful?

    Can’t find what you’re looking for?

    Contact Support