Question

When viewing a sheet, you want to have certain rows grab your attention, if the task is at risk or past its due date. You can accomplish this by using which feature?

a. Highlight changes
b. Conditional formatting
c. Alerts
d. Format painter

Answer 1

To have certain rows in a sheet stand out based on criteria such as being at risk or past due, the conditional formatting feature is used to apply specific formatting rules.

Step-by-step explanation:

When viewing a sheet and wanting certain rows to grab your attention, if the task is at risk or past its due date, you can accomplish this by using the conditional formatting feature. This feature allows you to apply specific formatting rules to cells that meet certain criteria. With conditional formatting, you can set up rules that specify how the formatting of a cell should change when the cell's value meets certain criteria. For example, you can set a rule that highlights the rows with overdue tasks in a sheet. For example, you can set a rule to change the background color of a cell to red if the due date has passed, making the row stand out and immediately signaling that the task requires attention.