Question: Using the Thompson Industries' supplier file provided below, enter $ 6 , 0 0 0 into cell Upper E 8 . In that spreadsheet, any
Using the Thompson Industries' supplier file provided below, enter $ into cell Upper E In that spreadsheet, any newany new supplier left parenthesis with a Y in column Upper J right parenthesis shouldwith a Y in column J should have its total purchasestotal purchases in column Upper D equal to its change from the previous monthequal to its change from the previous month in column Ein column E Analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to identify any newany new suppliers whose purchases do not meet thatthat conditioncondition. What formula should go into the box Format values where this formula is true: Hint: The Excel symbol for notHint: The Excel symbol for not equals toequals to is less than greater than is
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
