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.
- Rating
- 4.8(1.1K)
- Monthly uses
- 143K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
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
What people say
Our IT team blocked every other online tool because they upload files. This one does not, so conditional formatting assistant finally got approved for use on real data.
Small thing, but the error messages actually tell you what to fix. Conditional Formatting Assistant flagged a hidden character that had been breaking my lookups for weeks.
Our IT team blocked every other online tool because they upload files. This one does not, so conditional formatting assistant finally got approved for use on real data.
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