◆ Excel · track

Application Monitoring

Build a tracker table listing application number, officer, EIS received (Yes/No dropdown), EIS due date, and days over…

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”Build a tracker table listing application number, officer, EIS received (Yes/No dropdown), EIS…+
Build a tracker table listing application number, officer, EIS received (Yes/No dropdown), EIS due date, and days overdue; add conditional formatting to flag missing EIS past due, freeze headers, and include a totals row so case officers can follow up on outstanding statements.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before handing to the case officer team, make follow-up simpler — add an automated follow-up…+
Before handing to the case officer team, make follow-up simpler — add an automated follow-up column that shows last contact date and suggested next action, colour overdue items by severity, and provide a one-line macro or instruction to export only overdue cases for the weekly team meeting so nothing slips through.
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
Build a simple tracker that flags applications missing environmental impact statements so case officers follow up.

Who does this

1 roles
Urban Planner

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.