Administration and Executive AssistantTier 1015 minintermediate

Font Colour for Negative Values

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

What you will learn

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

Excel skills

Font Colour · Cell Formatting

The task

Eight account balances are listed, some negative. Colour the negative balances' font red so a reader can spot them 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