Case 15-2 Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name.
Zelda uses conditional formatting to make the following changes: change the background color of the cells with current salary of $3000 to $4000 to yellow, change the font color, generate data bars on each cell, and highlight the cells containing the names with blue color. In this scenario, which of the following changes will be applied first?
A)Generating data bars
B)Changing the color of the font
C)Changing the background color of the cells to yellow
D)Highlighting the background of the cells with blue color

Question

Quizplus · Accepted Answer

Conditional formatting in Excel applies changes based on the order of the rules set by the user. Changing the background color of cells based on specific values (in this case, a current salary of $3000 to $4000) is a direct application of conditional formatting rules, which typically take precedence in visual changes before more complex or additional formatting like data bars or font color changes.

Case 15-2 Zelda, the Human Resource (HR) Manager at ProfDot