Homework SourseThere is a formula in cell B17 and it is B12B14 The displaye
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?
Solution
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.
