Question: how do you find out how to do this stuff on excel? 5. The conditional formatting rule Dean created in the range G2:31 highlights staff

how do you find out how to do this stuff on excel?

5. The conditional formatting rule Dean created in the range G2:31 highlights staff members who were last First Aid certified 3 or more years ago (and will be required to retake the First Aid Certification class), but it doesn't stand out enough. Edit the conditional formatting rule applied to the range G2 G31, so that the highlighted cells are formatted using the bold font style and the Orange, Accent 2 font color (6th column, 1st row in the Theme Colors palette) Home Review View Insert Page Layout Formulas Data Caloridyl11 . AA Table General . X fx Service Years Realary Fruid Cartification Tear 1101 Adam Mary 16 Peterson 2,531 23223323

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 General Management Questions!

1.Dean Hilson is the director of Camp Bright Firewood. He started planning the camp staffing assignments for next year in an Excel table, and needs your help completing the table. First, he'd like to...

Module 8 Sam project 1 b . I need help with 4, 5, 7 New Perspectives Excel 2016 T Module 8:SAM Pr In cell G2, enter a formula without a function using structured references to determine the number of...

Sam Project for Advanced functions and conditional formatting Excel 2013 I am having trouble with questions 14-19. Assignment do tomorrow Computer Software 178 New Perspectives Excel 2013 Tutorial 8:...

Excel Module 8. I need help on 4,5,7. Expert Q&A Done Module 8 Sam project 1 b. I need help with 4, 5, 7 In cell G2, enter a formula without a function using structured references to determine the...

You are an assistant manager at Rough Stitch Clothing, a boutique clothing store. The store owner has asked you to generate a report detailing the financials of the store from 2018 to 2021 and, at...

1. Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center's classes....

How should the hlookup formula be entered into 2016 excel? In cell E2, enter a formula using the HLOOKUP function and structured references to determine a staff member's pay rate (which is based on...

Dean Yamaguchi is a development officer for the city of Honu Point in Hawaii. Dean is analyzing city development projects that have been completed, are in progress, and have been proposed. He asks...

New Perspectives Excel 2016 | M Module 8: SAM Project 1b references to determ column f The enter a formula without a function using structurth HR vear ethe number of years since Alison Simoneau...

Using consequential, rule-based, and character theories, evaluate Juanitas options. What should Juanita do? Why? Juanita Maxwell devotes a great deal of time and energy in getting to know her...

A firm has annual sales of $300,000, a price-earnings ratio of 24, and a profit margin of 4 percent. Profit margin is net income divided by sales. There are 15,000 shares of stock outstanding. a)...

Janis just won a scholarship that will pay her $ 5 0 0 a month, starting todang, and continuing for the next 4 8 months. Which one of the following terms best describes these scholarship peyments?...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...