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 $6,000 into cell Upper E8. In that spreadsheet, any newany new supplier left parenthesis with a 'Y' in column Upper J right parenthesis should(with 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 E.in 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 to''equals 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 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!