An example of conditional formatting is
A) formatting a spreadsheet with alternate colors for each row
B) applying currency format to cells that refer to monetary values
C) applying italics to one column and bold to another
D) applying a font color such as green to all values greater than 500

Question

Quizplus · Accepted Answer

Conditional formatting refers to the automatic application of formatting to cells based on the current contents of the cells. Choice D, applying a font color such as green to all values greater than 500, is an example of conditional formatting because it changes the appearance of cells based on their values meeting a specific condition (in this case, being greater than 500). Choices A, B, and C describe standard formatting that does not change based on cell contents.

An Example of Conditional Formatting Is