Days elapsed & Alert

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.