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...