17.2k views
3 votes
create a conditional format that applies red fill and white background 1 font color to the incidents (column b) that required 30 or more days to resolve.

User Melchia
by
8.3k points

1 Answer

4 votes

Now, imagine you have a list of incidents, and you want to highlight those that took a long time to resolve. Here's how to that that in Microsoft Excel.

1. Select the cells in column B (where incident details are).

2. Go to "Format" or "Home" tab, find "Conditional Formatting."

3. Choose "New Rule" or "Add Rule."

4. Select "Format cells that contain."

5. Set the condition to "greater than or equal to 30."

6. Click "Format" and choose red fill with a white font color.

7. Confirm and apply the rule.

Now, all incidents taking 30 or more days to resolve will stand out with red and white colors.

User Loknar
by
8.2k points