Hi All,
What I need to do is have a function which calculates the days elapsed between current date & time and a previous date & time and this calculation should stop when in status column “closed” is selected.
Also if the Days elapsed exceeds say 5 days then the entire row should be highlighted in red and if the days elapsed exceeds 10 days then the entire row should be highlighted in blue
I have enclosed/attached an sample file so that you can understand better what I need.
Link to the sample :
http://www.excelforum.com/excel-general/654718-days-elapsed-and-alert.html
What I need to do is have a function which calculates the days elapsed between current date & time and a previous date & time and this calculation should stop when in status column “closed” is selected.
Also if the Days elapsed exceeds say 5 days then the entire row should be highlighted in red and if the days elapsed exceeds 10 days then the entire row should be highlighted in blue
I have enclosed/attached an sample file so that you can understand better what I need.
Link to the sample :
http://www.excelforum.com/excel-general/654718-days-elapsed-and-alert.html
