DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Suppose you create two conditional format rules on a range of cells:Rule 1:Display an orange background color if the cell has a value > 7.5. Rule 2:Display a green background color if the cell has a value >=7.4. What background color will display if every value had a minimum value of 8?
|
|
Orange
|
|
|
Brown-both colors are applied and combined.
|
|
|
Green
|
|
|
It depends which rule is listed above the other in the Rules Manager dialog box.
|
Explanation:
Detailed explanation-1: -Apply Multiple Conditional Formatting Rules You can add many conditional formats to the same cell and range in order to get the desired effect.
Detailed explanation-2: -Highlight your cell or range of cells. From the Format menu, select Conditional Formatting… In the Conditional formatting dialog, select Cell Value Is in the first drop-down box. Select a cell evaluator from the second drop down box.
There is 1 question to complete.