Hay,
First conditional format :
=ET(L5="EMERGENCY";E5>2) Format cell = Red
Second and third conditional format :
=ET(L5="URGENT";E5>14) Format cell = Red
Fourth and fifth conditional format :
=ET(L5="URGENT";E5<365) Format cell = Green
You can see that there is a problem with the second-third and fourth-fifth hypothesis ?
Best regards
Bookmarks