Create a new conditional format that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve. Be sure to use relative cell references in the conditional format formula.
Create a new conditional format that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve. Be sure to use relative cell references in the conditional format formula.
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 2.5CP
Related questions
Question
Create a new conditional format that applies Red fill and bold font to incident (range A6:A85) that required 30 or more days to resolve. Be sure to use relative cell references in the conditional format formula.
![B
D
E
F
H
Technical Support Calls
Threshold
days
30
Incident Number|
Date created
Last Name Agent Name Computer ID
Cox
i Status
I Date Resolved
Duration
Description
Software Update
619-44822
2/10/2021 Silva
8950
Closed
2/12/2021
2
605-47583
3/9/2021 Garner
Сох
9589
Forgotten Password Closed
3/14/2021
4/26/2021 Walker
Dodson
9955
5/2/2021
Will not power on
Will not power on
424-30728
Closed
6.
5/2/2021 Delgado
3/13/2021 Hale
875-36070
Dodson
3488
Closed
5/28/2021
26
878-43585
Dodson
2853
Virus
Closed
3/21/2021
8.
727-78890
2/15/2021 Watts
Dodson
4468
Printing Issues
Closed
2/28/2021
13
4/11/2021|
5/7/2021|
4/5/2021
247-70541
3/24/2021 Rodgers
Dodson
2340
Software Update
Closed
18
5/5/2021 Griffin
Forgotten Password Closed
Will not power on
868-40830
Dodson
7125
2
859-12568
3/18/2021 Soto
Нays
8586
Closed
18
309-20285
2/20/2021 Coleman
Нays
3198
Will not power on
Closed
3/20/2021
28
3/3/2021 Ramirez
Closed
3/24/2021
751-81316
Нays
9751
Virus
21
3/29/2021 Gray
1/16/2021 Washington Hays
179-51542
4/9/2021
Software Update
Software Update
Нays
1577
Closed
11
Closed
2/9/2021
657-68422
6405
24
614-70314
2/20/2021 Gutierrez
Leggett
3801
Software Update
Closed
3/3/2021
11
683-70001
3/22/2021 Newman
Leggett
6580
Forgotten Password Closed
3/26/2021
4
422-24141
2/18/2021 Carpenter
3/14/2021 Hines
Leggett
4978
Forgotten Password Closed
2/26/2021
8
164-64518
Rousaux
1675
Will not power on
Closed
6/12/2021
90
218-35195
1/13/2021 Ross
Rousaux
6735
Virus
Closed
1/27/2021
14
556-31818
5/18/2021 Graham
Rousaux
9795
Software Update
Closed
6/5/2021
18
816-11026
5/28/2021 Parks
Vong
6632
Will not power on
Closed
7/21/2021
54
859-45748
1/11/2021 Lee
Vong
5070
Virus
Closed
1/18/2021
7
131-31453
2/13/2021 Medina
Vong
Closed
2/18/2021|
5469
Printing Issues
1/15/2021 King
Vong
Printing Issues
Closed
1/26/2021
11
399-98477
7426](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F049f3e9e-c348-4dfe-9c15-657b4da14545%2F055041be-b7be-4564-881d-c116fcef5adc%2F50neypc_processed.png&w=3840&q=75)
Transcribed Image Text:B
D
E
F
H
Technical Support Calls
Threshold
days
30
Incident Number|
Date created
Last Name Agent Name Computer ID
Cox
i Status
I Date Resolved
Duration
Description
Software Update
619-44822
2/10/2021 Silva
8950
Closed
2/12/2021
2
605-47583
3/9/2021 Garner
Сох
9589
Forgotten Password Closed
3/14/2021
4/26/2021 Walker
Dodson
9955
5/2/2021
Will not power on
Will not power on
424-30728
Closed
6.
5/2/2021 Delgado
3/13/2021 Hale
875-36070
Dodson
3488
Closed
5/28/2021
26
878-43585
Dodson
2853
Virus
Closed
3/21/2021
8.
727-78890
2/15/2021 Watts
Dodson
4468
Printing Issues
Closed
2/28/2021
13
4/11/2021|
5/7/2021|
4/5/2021
247-70541
3/24/2021 Rodgers
Dodson
2340
Software Update
Closed
18
5/5/2021 Griffin
Forgotten Password Closed
Will not power on
868-40830
Dodson
7125
2
859-12568
3/18/2021 Soto
Нays
8586
Closed
18
309-20285
2/20/2021 Coleman
Нays
3198
Will not power on
Closed
3/20/2021
28
3/3/2021 Ramirez
Closed
3/24/2021
751-81316
Нays
9751
Virus
21
3/29/2021 Gray
1/16/2021 Washington Hays
179-51542
4/9/2021
Software Update
Software Update
Нays
1577
Closed
11
Closed
2/9/2021
657-68422
6405
24
614-70314
2/20/2021 Gutierrez
Leggett
3801
Software Update
Closed
3/3/2021
11
683-70001
3/22/2021 Newman
Leggett
6580
Forgotten Password Closed
3/26/2021
4
422-24141
2/18/2021 Carpenter
3/14/2021 Hines
Leggett
4978
Forgotten Password Closed
2/26/2021
8
164-64518
Rousaux
1675
Will not power on
Closed
6/12/2021
90
218-35195
1/13/2021 Ross
Rousaux
6735
Virus
Closed
1/27/2021
14
556-31818
5/18/2021 Graham
Rousaux
9795
Software Update
Closed
6/5/2021
18
816-11026
5/28/2021 Parks
Vong
6632
Will not power on
Closed
7/21/2021
54
859-45748
1/11/2021 Lee
Vong
5070
Virus
Closed
1/18/2021
7
131-31453
2/13/2021 Medina
Vong
Closed
2/18/2021|
5469
Printing Issues
1/15/2021 King
Vong
Printing Issues
Closed
1/26/2021
11
399-98477
7426
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning