Hi

Is that possible to track the occurrence of number in specific cells (with certain criteria such as less then 10)?

Imagine Case:
In Cells A1
Contain some formula which will make the number change everyday. Number that less than 10 will turn to red color font.

In Cells A2
(Maybe some excel format or Macro language which) Able to track how many time that number less than 10 occur in Cell A1.
**This tracking was able to sustain more than 30 days. (Which mean the excel file will close when it is not use or shut down the computer during rest time or night time)

Thanks in advance