FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to get the B cells to highlight green if the values in cells c are greater then 10 and red if less

I am trying to get the B cells to highlight green if the values in cells c are greater then 10 and red if less then 10. The picture is what I have so far however, I just cant figure out the formula so Ecxel will understand it. image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Project Management Made Simple

Strategic Project Management Made Simple

Authors: Terry Schmidt

1st Edition

0470411589, 978-0470411582

More Books

Students also viewed these General Management questions

Question

★★★★★
A machine component is subjected to the forces and couples shown. The component is to be held in place by a single rivet that can resist a force but not a couple. For P = 0, determine the location of...

Answered: 1 week ago

Question

★★★★★
You begin work on June 1 and work until August 31, and receive pay on the last day of the month. Your expenses for these three months are $1500/mo. At the end of September, you make a $7000 payment,...

Answered: 1 week ago

Question

★★★★★
1. What is the difference between the mind and the brain?

Answered: 1 week ago

Question

★★★★★
Multiple Choice Questions Indicate the best answer for each of the following: 1. For the spring semester of 20X4, Lane University assessed its students $3,400,000 (net of refunds) of tuition and fees...

Answered: 1 week ago

Question

★★★★★
The Heartlake Corporation manufactures and sells toy gyroscopes. The following data is related to sales and production of the toy gyroscopes for last year Selling price per unit S8.40 S1.84 Variable...

Answered: 1 week ago

Question

★★★★★
In the diagram below of AACT BET CB 3 C4 10 am CE 6 what is the length of CT A 26 B OC 20 14

Answered: 1 week ago

Question

★★★★★
Describe how a company's failure to determine its design capacity and system capacity will affect its ability to turn a profit. Give a concrete example to demonstrate this effect Note: In Essay Form

Answered: 1 week ago

Question

★★★★★
Q 1 . ?Consider the anthropomorphic arm as shown in Fig. where the link frames have been illustrated, determine the manipulator Jacobian matrix and analyze it . ( solve with complete step numerically...

Answered: 1 week ago

Question

★★★★★
As a health care consumer who recently switched to a managed care health plan, you were very worried about the quality of the care provided to you. You were wondering if there were any reviews of...

Answered: 1 week ago

Question

★★★★★
Given the estimated regression equation E(Y) = 30 + 2(x1) - 3(x2) + 10(x1x2) where x1= age and x2-gender (0 is female, 1 otherwise) what is the estimated value of Y when x1= 30 and x2-female? 90 387...

Answered: 1 week ago

Question

★★★★★
Consider a call center for software support: - 3 representatives answer phones (each can handle all types of calls) - Calls arrive according to a Poisson process. On average, there are 20 calls per...

Answered: 1 week ago

Question

★★★★★
What other steps would you suggest the company take to boost safety? For instance, what would you have supervisors do to improve the companys safety and accident record?

Answered: 1 week ago

Question

★★★★★
What other non-union surprises do you think Walmart should be planning its HR practices for in China?

Answered: 1 week ago

Question

★★★★★
Do you agree that safety in the office is a matter of attitude? Why or why not?

Answered: 1 week ago

Previous Question Next Question