ExcelBanter - Cell colour change for a set time period

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Cell colour change for a set time period (https://www.excelbanter.com/excel-programming/445824-cell-colour-change-set-time-period.html)

schugh

Cell colour change for a set time period

I have a spreadsheet that has a column that only contains the characters E ? and [ is it possible for a cell where the data is changed from one character to another to change colour for a 30 minute period??? any help would be greatly appreciated.

All times are GMT +1. The time now is 10:26 AM.