Conditional Formatting Assistant
Build highlight rules without wrestling the dialog box.
Describe the rule you want — highlight overdue rows, flag values above target, colour-scale a margin column — and get the formula and settings to paste into Excel, plus a downloadable workbook with the rule already applied.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Whole-row highlighting formulas with correct mixed references
- Data bars, colour scales and icon sets configured for you
- Rules written into a real XLSX so they open natively in Excel
How to use Conditional Formatting Assistant
- 1
Optionally upload the workbook you want to format.
- 2
Describe the rule and choose the range it applies to.
- 3
Pick the highlight style — fill, data bar, colour scale or icon set.
- 4
Copy the rule formula, or download the workbook with it applied.
Watch a walkthrough
Common problems and fixes
The highlight applies to the wrong rows.
The applies-to range starts at a different row than the formula assumes. Make the first row of the range and the row in the formula match.
Formatting slows the workbook down.
The rule targets entire columns. Scope it to the real data range — the Workbook Optimizer flags this too.
Frequently asked questions
More formulas tools
Describe what you need in plain English and get a working formula, or paste an existing one to see it explained and audited step by step.
Browse Formulas