Create beginner Works with: Any AI

Conditional Formatting Rule Writer

Few shot Has example

Highlight what matters with custom rules.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Write conditional formatting rules for my sheet. App: [SPREADSHEET_APP]. Range and columns: [RANGE_AND_COLUMNS]. What should be highlighted and in which color: [HIGHLIGHT_NEEDS]. Sample data (fake): [SAMPLE_DATA].

For each need, provide: the range it applies to; the custom formula rule; the formatting; an explanation of how the references work (relative versus absolute, with dollar signs); and a test.
Examples to follow:
Highlight the whole row when status in column D is "Overdue": apply to A2:H100, formula =$D2="Overdue".
Highlight dates due in the next 7 days: =AND($C2>=TODAY(), $C2<=TODAY()+7).
Highlight duplicates in column A: =COUNTIF($A$2:$A$100,$A2)>1.
Highlight values below the average: =B2<AVERAGE($B$2:$B$100).
Alternate row shading: =ISEVEN(ROW()).
Highlight blank required cells: =AND($A2<>"", B2="").

Also cover: rule order and priority; stopping when a rule is true; color choices that are accessible (contrast and not relying on color alone, with icons or text); performance on large ranges; and how to find and clean up conflicting rules. End with a style guide for a consistent color meaning in the workbook and a checklist to review all rules.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Need | Applies to | Formula | Format
Highlight the row when status is Overdue | A2:H100 | =$D2="Overdue" | light red fill
Due in the next 7 days | C2:C100 | =AND($C2>=TODAY(), $C2<=TODAY()+7) | amber
Duplicates in column A | A2:A100 | =COUNTIF($A$2:$A$100,$A2)>1 | bold with border
Below average | B2:B100 | =B2<AVERAGE($B$2:$B$100) | italic
Dollar signs make the column fixed ($D2) and the row relative. Accessibility: add an icon or text flag, not color alone. Review rule order and clear conflicting rules.

• conditional-formatting