Negative time in red

how do I change the format of a cell with a negative time “-HH:MM” to RED txt?

ps I need the time to roll over, ie +24 hours. 70, 80, 90, hours may be needed. 24 hour limit is of no use to me.

Use [HH]:MM:SS;[RED]-[HH]:MM:SS cell format.

PS: Don’t “answer” questions with new questions or with clarifications to original questions. If the original question is yours, and you want to clarify, then edit it to add new data; if not, and if you are asking a new question, then create new question for that.

See guidelines for asking.