Need Help. Conditional formatting a cell if between two values or not between

Hi, I have searched all around but cannot get anything to work. What I want to do is create conditional formatting or VBA (with some help) to fill a cell RED if MAX(I4:R4)>MAX(E4:F4), MIN(I4:R4)<MIN(E4:F4) Else fill cell green.
Im open to any suggestions, solutions. I have a attached a sample of what I would like to do.
Thanks a head of time.