The ImportExcel PowerShell module by Doug Finke allows users to import and export data in PowerShell to an Excel spreadsheet (.xlsx). This is my most-used module and my go-to for creating reports.

Most of the reports can be created with just the default export of PowerShell objects to a single worksheet. I normally create the spreadsheet as part of a table to make it easier to navigate:


While this is fine for most use cases, there is sometimes a need to highlight certain cells based on a value. In this example, we have a column for Disk size and another column for Free Disk space. I was asked to highlight cells with less than 5% disk space:


Some of the other asks have been regarding formatting, font size, cell borders, etc: