Conditional formatting based on Cell above… Unless

I am using conditional formatting to colour cells based on a comparison of data between cells. It’s a complex scenario with different outcomes needed.

The first outcomes I will detail and they are quite easy –

1. blank cells should have no colour
2. cells with a hyphen should have no colour
3. cells with a value lower than the cell above should be red
4. cells with a value higher than the cells above should yellow
5. cells with a value lower than the cells below should be orange

And that has worked fine, however, there are some advanced rules I have run into problems with:

4. cells with a value higher than the cells above should yellow UNLESS the cell above is blank
5. cells with a value lower than the cells below should be orange UNLESS the cell below is blank

Well, I have some other problems… but this is a good place to start! Any help is appreciated 🙂

Here is my conditional formatting. The first line is attempting to resolve the issue(not working):
myconditionalformatting

and here is a selection of the data:
mydata

It’s a mind melter!
Thanks