If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?
A)Conditional formatting
B)AutoFill formatting
C)AutoComplete formatting
D)Aggregate Cell formatting

Question

Quizplus · Accepted Answer

Conditional formatting is the feature that allows you to apply formatting to cells based on specific conditions. In this case, you would set the condition to be cells that have a value over $1,251 and then choose the purple fill as the formatting to be applied.

If You Wanted Every Cell That Has a Value Over