1 2 3 4 5 6 7 8 9 10

Cadence has a large worksheet with dozens of columns of data that are totaled at the bottom. She wants to change the formatting of cells with the word "Total" bolded and red so the cells stand out. What is the quickest way for Cadence to do this?

A Applying the Conditional Formatting option "Text that Contains ... "

B clicking Control on a cell with the word "Total"

C scrolling through and looking for the word "Total" then changing the formatting

D right-clicking on one cell with the word "Total" and applying a Conditional Formatting option

Question

Derick Cisneros

Computers & Technology

26 January, 12:37

1 2 3 4 5 6 7 8 9 10

Cadence has a large worksheet with dozens of columns of data that are totaled at the bottom. She wants to change the formatting of cells with the word "Total" bolded and red so the cells stand out. What is the quickest way for Cadence to do this?

A Applying the Conditional Formatting option "Text that Contains ... "

B clicking Control on a cell with the word "Total"

C scrolling through and looking for the word "Total" then changing the formatting

D right-clicking on one cell with the word "Total" and applying a Conditional Formatting option

+2

Answers (1)

Know the Answer?

Ezequiel Duarte · Answer 1

The correct answer is A) Applying the Conditional Formatting option "Text that Contains ... "

In an Excel worksheet, you can quickly conditionally format a row based on the text in one of the cells in the row. To do that, you should simply select the cells that you want to apply conditional formatting to. Click the 1st cell in the range and drag it to the lastone. Click Home Button, Conditional Formatting, Highlight Cells Rules and then enter the text in the Text that Contains box.