Search for courses or lessons
Redeem a coupon
Start free trial
Suppose cells A5 and A6 contain the numbers 48 and 40 respectively. For both cells the custom conditional format rule is =$A$5>45 which executes a red font. What font color will A6 show?
The default color on the cell (the rule is false, so it doesn’t trigger a change)
There is not enough information to tell
Suppose cell D5 has two conditional formatting rules in place, as shown below. The first rule turns the font blue if the value exceeds 10. The second rule turns the background yellow and the font red if the value exceeds 20. What is required for a value of 25 to be displayed with a red font and yellow background?
Put the yellow rule first and select Stop if True
Put the blue rule first and select Stop if True
Put the yellow rule first
Suppose cell D5 has two conditional formatting rules in place as shown below. The first rule in the manage rules list turns the font blue if the value exceeds 10. The second rule in the manage rules list turns the background yellow and the font red if the value exceeds 20. The value in D5 is currently 25. What color scheme will the cell display?
Red font with yellow background
Blue font with white background
Blue font with yellow background
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement