Google Sheets conditional formatting with AI checklist

Checklist

Raw source material is preserved before AI edits begin.The desired output format is written explicitly.Edge cases, missing values, and exceptions are listed.The first output is reviewed against real examples.The final prompt is stored for reuse.Sensitive or policy-heavy cases get manual review.Define the condition and visual outcome.List the columns and thresholds.Ask for rule logic and examples.Test the rules on a copy of the sheet.

Mistakes to avoid

using too many colors

Make the prompt more specific, keep the source data visible, and review the output before using it in a live workflow.

hiding logic inside formatting only

Make the prompt more specific, keep the source data visible, and review the output before using it in a live workflow.

not defining thresholds

Make the prompt more specific, keep the source data visible, and review the output before using it in a live workflow.

forgetting a test sheet

Make the prompt more specific, keep the source data visible, and review the output before using it in a live workflow.

Related workflow pages