J
j5b9721
I have 10 (day) cells with 2 different Conditional Formats in the 5 days LOG.
conditions are - One is low quanity one is high quanity.
Above - in another cell I have dates.
I need to know without looking back what condition triggered last.
A B C D E F G
J K L
LINE 5 5-OCT 6-OCT 7-OCT 8-OCT 9-OCT 12-OCT 13-OCT 14-OCT
LINE 6 hIGH 648
LINE 7 lOW 574 570 600 655 600 660 620
550 576
LO HI = Triggerd LO HI HI
LO
Thanks for looking...
conditions are - One is low quanity one is high quanity.
Above - in another cell I have dates.
I need to know without looking back what condition triggered last.
A B C D E F G
J K L
LINE 5 5-OCT 6-OCT 7-OCT 8-OCT 9-OCT 12-OCT 13-OCT 14-OCT
LINE 6 hIGH 648
LINE 7 lOW 574 570 600 655 600 660 620
550 576
LO HI = Triggerd LO HI HI
LO
Thanks for looking...