I stuck the second formula into a cell in a new blank worksheet and the cell shows "TRUE" so it is just a problem with conditional formatting. How strange.