Administration and Executive AssistantTier 1015 minintermediate

Background Fill for a Status Highlight

Shade only the overdue tasks, so they jump out from a longer list.

What you will learn

• Apply a background fill colour to specific cells
• Explain why a highlight only works when applied to the exact rows that need it
• Recognise manual fill as distinct from a conditional-formatting rule that updates itself

Excel skills

Background Fill · Cell Formatting

The task

An eight-task list has a Status column. Shade the background of every "Overdue" status cell in light red so it jumps out from the list - and leave every other status as it was.

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