Administration and Executive AssistantTier 012 minbeginner

Font Colour and Background Fill

Flag a negative budget variance in red and shade an at-risk project, 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 project list has a negative budget variance and an at-risk project, neither of which stands out. Colour the negative variance (B2) red, and shade the at-risk 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