What types of formatting rules are supported?

The tool supports threshold-based cell highlighting, data bars, color scales, and text-contains rules.

Can I apply multiple rules to the same range?

Yes, you can define an array of rules in the JSON configuration to apply multiple formatting layers to the same or different ranges.

Is my original file modified?

No, the tool generates a new processed file, leaving your original source file unchanged.

What format should the Rules JSON follow?

The JSON should be an array of objects, each containing keys for sheetName, ref (range), type, and specific parameters like fillColor or operator.

Are there limits on the file size?

The tool supports files up to 20MB to ensure efficient processing.

Elysia Tools

Navigation

Format Conversion

XLSX Conditional Formatting Rule

Batch-apply conditional formatting rules such as threshold highlights, data bars, and color scales to Excel worksheets

Details

What this tool helps you do

Apply conditional formatting in batch.

Supports threshold rules like value > 100 in red
Supports data bars and 2/3-color scales
Supports text contains and formula expression rules
Uses ExcelJS native conditional formatting support

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

Examples that match this tool

Continue with connected tools and hubs

[ { "sheetName": "2026 Sales", "ref": "H2:H100", "type": "cellIs", "operator": "greaterThan", "formulae": [100000], "fillColor": "#DCFCE7", "fontColor": "#166534" }, { "sheetName": "2026 Sales", "ref": "I2:I100", "type": "dataBar" } ]

XLSX Conditional Formatting Rule

What this tool helps you do

Run this tool

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Prepared example runs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Automated KPI Performance Dashboard

2. Inventory Risk Assessment

FAQ

XLSX Samples

XLS Samples

Android Serialization Java Samples

Android Serialization Kotlin Samples

Excel to JSON Converter

XLSX Chart Embedder

XLSX Parquet Exporter

XLSX Print Setup Pack

Excel and XLSX Data Automation Tools

JSON Interchange and Format Translation Tools

XML Conversion, Mapping, and XPath Tools

JSON Inspection, Diff, and Transformation Tools