Question: Create a new conditional format that applies Red fill and bold font to incident ( range A 6 :A 8 5 ) that required 3

Create a new conditional format that applies Red fill and bold font to incident

(

range A

6

85)

that required

30

or more days to resolve. Be sure to use relative cell references in the conditional format formula.Can someone explain step by step? Where Do i put my formula box after clicking on new rule? I don't understand

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Steps to Perform: Step Instructions Points Possible 1 0 2 5 3 13 4 6 5 4 Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has automatically added your last name to the...

Need help in these. thanks in advance Steps to Perform: Step Instructions Points Possible 1 0 2 5 3 13 4 6 5 4 Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has...

Exp19_Excel_Ch04_Cap_Tech_Support Project Description: You have been hired as a student assistant in the IT department of your University. As part of your responsibilities, you have been asked to...

Step Instructions Point Value 1 Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has automatically added your last name to the beginning of the filename. 0 2 Freeze Panes so...

Need help on questions 11 through 13. on Freeze Panes so the first row containing column headings (Row 5) on the SupportCalls worksheet wil remain static when scrolling. Ensure that Rows 1-4 are...

Exp19_Excel_Ch04_Cap_Tech_Support Project Description: You have been hired as a student assistant in the IT department of your University. As part of your responsibilities, you have been asked to...

8 Sort the table by Agent Name in alphabetical order, add a second level to sort by Description, and create a custom sort order as follows: Will not power on , Virus, Printing Issues, Software...

Need help with these questions in Excel! Thank you very much. 7. Add a total row to display the Average days required to resolve an issue. 8. Sort the table by Agent Name in alphabetical order, add a...

Filter the table to only display closed incidents as indicated in the status column. Use Quick Analysis to apply the default Data Bars conditional formatting ( Solid Blue Fill ) to the Duration...

I need help with the following questions (with visuals) for an Excel Document. Here is the Document: https://1drv.ms/x/s!AoQGMTkNnGG_hHovxQiTrwkoaRTc Instructions: For the purpose of grading the...

Bonny Corp. has a defined benefit pension plan for its employees who have an average remaining service life of 10 years. The following information is available for 2013 and 2014 related to the...

Which prong did the County of San Francisco satisfy in the case Ambat v. City & County of San Francisco? Why? Explain.

When using the cash flow function on the class calculator, the calculator will ask you for what information? the size of the cash flows and the interest rate. the size of the cash flows and the year...

OZ Bank has the following balance sheet (in millions) and has no off-balance sheet activities: Assets Liabilities and Equity Deposits $2,900 Residential mortgages 400 Commercial loans, CCC+ rated...