Domain 2File Management, Data Processing & Output

Conditional Formatting

TL;DR

Rules applied to Excel cells that automatically change their visual appearance based on the data they contain.

Definition

Rules applied to Excel cells that automatically change their visual appearance based on the data they contain. Cowork can apply conditional formatting — for example, highlighting any expense over $500 in red or flagging regions below target in amber — as part of a workbook creation task.

Exam Context

Know that conditional formatting is part of Cowork's Excel capabilities but requires explicit specification in your prompt. Without instructions, Claude defaults to the simplest output.

Related Lessons

Related Terms in Domain 2