Conditional formatting from other spreadsheet

Closed
cleggwde - Jul 15, 2016 at 09:28 AM
 Blocked Profile - Jul 15, 2016 at 09:34 AM
Hello,

Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be able to see if on 7/14 the customer demand was 2,400 then on 7/15 the customer demand changed to 3,900. How would I go about doing that using conditional formatting?

1 response

Blocked Profile
Jul 15, 2016 at 09:34 AM
How does one qualify the demand change, does he expect a certain percentage of rise?



In the above example, I selected Conditional Formatting, New rule, set up rules based on formula, then made my formula. In this example, all I did was calculate to see if E5/D5 was greater the 1.9. If it is then highlight the cell RED!

It's kind of fun to do the impossible! -Walter Elias Disney
0