excel-outlier-detection-and-highlighting

To automatically highlight outliers in Excel, this Skill scans cells to extract limit patterns from textual content, flags numeric values exceeding predefined thresholds, and applies red highlighting to out-of-range rows while generating a summary report for review.

Yes, this Skill handles data validation and auditing across large spreadsheets containing mixed numeric and textual data, identifying erroneous cells and highlighting threshold violations to streamline large-scale data cleanup and quality control workflows.

You load your Excel workbook and configure the detection rules to define acceptable thresholds; the Skill then processes the workbook to highlight out-of-range values and erroneous cells, outputting an annotated file and a brief summary report for auditing.

The Skill requires reading and writing Excel files using libraries like openpyxl to process cell content, extract limit patterns, apply red highlighting to flagged rows, and output the modified workbook along with a generated summary report.

The best way to clean up anomalous data in financial audit spreadsheets is to automate outlier detection by extracting limit patterns from cell text, flagging values that exceed thresholds, and applying red highlighting to generate a clean, auditable summary report.