There is a formula in cell B17 and it is =B12*B14. The displayed value in the ce

Question

There is a formula in cell B17 and it is =B12*B14. The displayed value in the cell is 100,000. When you change the value in cell B12, the value in B17 changes to 90,000 and the font in cell B17 changes from red to blue. What is the most likely explanation? There is a formula in cell B17 and it is =B12*B14. The displayed value in the cell is 100,000. When you change the value in cell B12, the value in B17 changes to 90,000 and the font in cell B17 changes from red to blue. What is the most likely explanation?

Explanation / Answer

Answer:

Conditional formatting has been applied to cell B17.

Explanation:

Conditional formatting is a tool that helps to format a cell or a range of cells based on the value of the cell.

For example, this type of formatting enables one to highlight cells with a specific color depending upon the cell's value.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.