Hi
I have a data validation drop down list containing many items, but two of the items on the list when they are selected I want to jump to a cell and begin a count down timer in that cell.
The drop down list is at E16:E150. When item "X" is selected, I want it it to go to H16 and begin a countdown timer of 15 minutes. I'd like that cell to turn a certain color when the countdown timer is done.
I have another item in the drop down list, item "Z" when it is selected I want it to go to H16 and begin a countdown timer of 30 minutes. I'd also like this cell to turn a certain color when the countdown timer is done.
This is a data entry excel sheet, so I would like this timer option to be available on each row (H16:H150) if I decide to choose it from the drop down list.
Thank you
I have a data validation drop down list containing many items, but two of the items on the list when they are selected I want to jump to a cell and begin a count down timer in that cell.
The drop down list is at E16:E150. When item "X" is selected, I want it it to go to H16 and begin a countdown timer of 15 minutes. I'd like that cell to turn a certain color when the countdown timer is done.
I have another item in the drop down list, item "Z" when it is selected I want it to go to H16 and begin a countdown timer of 30 minutes. I'd also like this cell to turn a certain color when the countdown timer is done.
This is a data entry excel sheet, so I would like this timer option to be available on each row (H16:H150) if I decide to choose it from the drop down list.
Thank you