Hi

I would like help with a formula to do the following

If cell A is >= cell B or <= cell C then display the test "FAIL" and highlight the cell red otherwise display the text "PASS"

Try as I might I have been unable to make a formula to get this to work