You can use conditional formating (the most visual) or If formula in the next
column

"Angela" wrote:

In controlling inventory I have for instance an item that the max quantity
needs to be at 5 days on each Monday of the week. If that item goes above .5
of a day what formula can I use to reflect this information?

Thank you,