Question

Chuck wants to bold every cell after row 19 in his document. What sequence would generate this change?

right-clicking row 19, Conditional Formatting, Highlight Cells Rules, Greater Than, Bold
right-clicking row 19, Conditional Formatting, Highlight Cells Rules, Less Than, Custom Format, Bold
Styles, Conditional Formatting, Highlight Cells Rules, Greater Than, select row 19, Custom Format, Bold
Styles, Conditional Formatting, Highlight Cells Rules, Less Than, select row 19, Bold

Answer 1

If Chuck wants to bold every cell after row 19 in his document. select row 19, highlight all other rows after row 19, right click , Format, click font, then choose Bold Styles.

Answer 2

Conditional formatting is commonly used in Microsoft Excel to apply a formatting style according to a set condition by the author, for example 'for values greater than cell 11B the color of the cell should be red'.

When you want to create changes in the visual format of your data, you should use this function. Thus, Chuck should use the steps outlined in (C) Styles, Conditional Formatting, Highlight Cells Rules, Greater Than, select row 19, Custom Format, Bold to achieve his goal.