Bird
0
0

If a conditional formatting rule colors values blue when below 300 and orange when 300 or above, what color will a cell with value 275 display?

medium📝 Formula Result Q4 of 15
Power BI - Formatting and Design
If a conditional formatting rule colors values blue when below 300 and orange when 300 or above, what color will a cell with value 275 display?
AGreen
BOrange
CNo color
DBlue
Step-by-Step Solution
Solution:
  1. Step 1: Analyze the rule

    Values below 300 are colored blue.
  2. Step 2: Check the cell value

    275 is less than 300.
  3. Final Answer:

    Blue -> Option D
  4. Quick Check:

    Value 275 < 300 means blue [OK]
Quick Trick: Compare value to threshold for color [OK]
Common Mistakes:
  • Confusing greater than and less than conditions
  • Assuming default color applies
  • Mixing up color assignments

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes