◆ Excel · track

Financial Analysis

Compare planned versus actual spend by department each week to see where we’re running over budget: import weekly spen…

2heights
2tasks
1roles do it
See the prompt↓More track workflows

The same job, four prompts

do it · improve it · decide · become
AExecute — “help me do it”Compare planned versus actual spend by department each week to see where we’re running over…+
Compare planned versus actual spend by department each week to see where we’re running over budget: import weekly spend, build a pivot by department showing planned vs actual, add a variance column, and save the weekly spend snapshot by Monday 09:00.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before I show producers weekly variances, make it actionable: add conditional formatting to…+
Before I show producers weekly variances, make it actionable: add conditional formatting to highlight departments over threshold, include a calculated field showing percent of weekly budget spent, surface the top three drivers of variance, and add one-line recommended actions for each over-budget department.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

How to do it

the tool · the steps · what to avoid
The tool
Conditional Formatting

Conditional Formatting in Excel automatically changes the appearance of cells based on criteria you define, helping you highlight important data, trends, and patterns.

  1. 1

    Select the cells or range of rows you want to format.

    NoteThis can be a single cell, a range (e.g., A1:E5), or an entire column.

  2. 2

    On the Home tab, in the Styles group, click Conditional Formatting.

  3. 3

    Click New Rule from the drop-down menu.

  4. 4

    In the New Formatting Rule dialog box, select a rule type.

    NoteCommon types include 'Use a formula to determine which cells to format' or 'Only format only top or bottom ranked values'.

  5. 5

    Enter your specific criteria or formula in the provided field.

    Best practiceFor budget tracking or expense analysis, use formulas to highlight over-budget items or spending anomalies.

  6. 6

    Click the Format button to choose your desired formatting style.

    NoteYou can set background color shading, foreground color shading (fonts), data bars, or icons.

  7. 7

    Click OK to apply the chosen format.

  8. 8

    Click OK again in the New Formatting Rule dialog box to create the rule.

  9. 9

    To manage multiple rules, click Conditional Formatting, then Manage Rules.

    NoteYou can change rule precedence using the up and down arrow buttons.

Use conditional formatting to instantly highlight important data for budget monitoring, financial comparison, and application monitoring thresholds.

Conditional Formatting can be automated and managed programmatically using VBA (Visual Basic for Applications) within Excel, allowing for dynamic rule creation and modification.

Glossary

words on this page
Conditional FormattingApplies specific formats to cells automatically when their values meet certain criteria.ExampleCells with sales figures below target automatically turn red, making underperforming regions easy to spot.
New Formatting RuleA command used to create a specific condition and its corresponding format for cells.ExampleYou can set cells to turn red if their value falls below a certain number.

The real tasks

1 of them
Compare planned versus actual spend by department each week to see where we’re running over budget.

Who does this

1 roles
Production Assistant

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.