Hi all and good afternoon!
Does anyone have a method of periodically running a function checks a range of adjacent cells in a column containing time values, and then bolds the time closest to the current time. I'd like my task list which contains scheduled times to show me which task is closest to the current time of day, by bolding the time. I've read about onTime briefly, and looked at functions which run when the sheet is opened, but is there a way to have a function run once every 15 minutes on a sheet? I'm working with an already slow workbook with lots of calculations already, and I wasn't sure if there was a low impact method to do this calculation-wise, or that wasn't polling constantly?
Best,
Frank
Bookmarks