After several days of futile attempts, I turn to you all for an answer that eludes me.
I am writing a planning spreadsheet that totals time used in a concert as each piece and its timing is entered. I need to have one cell that will recognize that the total time for the pieces has changed and alert the user to change an ancillary value elsewhere on the sheet.
Thus, if the total time = 0:10:00 and the user enters another piece that is 0:1:35 long, the new total would be 0:11:35. So far, so good, my sheet does that just fine.
Where I crash is in making a single-cell conditional alert formula that compares the new total with the old, and, if there is a change, it will alert the user with text in that cell.
Can you help, please.
maestrogn