FinanceTier 012 minbeginner

Font Colour and Background Fill

Flag a negative balance in red and shade a flagged account, without colouring the whole sheet.

What you will learn

• Apply font colour to flag a specific value based on its content
• Apply background fill to highlight a specific status
• Explain why colour only works as a signal when applied selectively

Excel skills

Font Colour, Background Fill · Cell Formatting

The task

This account list has a negative balance and a flagged account, neither of which stands out. Colour the negative balance (B2) red, and shade the flagged status (C4) light yellow so it jumps out from the list.

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