Conditional formatting using dates [Closed]

Registration date
Monday September 12, 2016
Last seen
September 12, 2016

Can anyone help please?

I have:

a column (E) of cells each containing options from a dropdown list named

Depending on which option i choose i need the cell on the same row in column (H) to run a formula that counts down days from the current date, that will run into negative days past due.
"MINOR" 10 days
"MAJOR' 5 days
"CRITICAL" 1 day

If possible i then need that countdown to stop when I enter the current date in cell on same row column (I)

Is this possible?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!