FinanceTier 1012 minintermediate

Red Font for Negative Balances

Colour only the negative account balances red, so they stand out without colouring everything.

What you will learn

• Apply font colour to specific cells based on their value
• Explain why colour only works as a signal when applied selectively
• Recognise the difference between flagging an outlier and colouring an entire column

Excel skills

Font Colour · Cell Formatting

The task

Eight account balances are listed, one negative. Colour the negative balance's font red so a reader can spot it without reading every number - and leave the positive balances exactly as they were.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free