Conditional formatting using dates [Closed]

Report
Posts
1
Registration date
Monday September 12, 2016
Status
Member
Last seen
September 12, 2016
-
Hi,

Can anyone help please?

I have:

a column (E) of cells each containing options from a dropdown list named
"MINOR"
"MAJOR"
"CRITICAL"

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!