These are two 2x2 matrices multiplied in series.

The first is the result of a multiplication of two tests, which is basically an AND test if I'm thinking straight.

If H4 is not text (i.e. not Type=2) AND if H4 is not blank, then TRUE, otherwise FALSE. The second part, I would prefer ISBLANK(H4). Thus I would write it...

=AND(TYPE(H4)<>2,ISBLANK(H4))

The second is an OR of H4<E4 and H4>G4. Obviously, an equivalence in either, H4 equals E4 or G4, would result in a FALSE.

Thus, if either E4>H4 OR H4>G4, Then TRUE, otherwise FALSE.

The end result is a number, either 1 or 0, TRUE or FALSE, etc. That result I suppose is conditionally formatted. If you could attach a sample sheet, I could see how it works. It seems kludgy.