Conditional formatting formula reporting false incorrectly

Question

=IF(AND((I1:I1000<TODAY()),((ISBLANK(O1:O1000))),(NOT(ISBLANK(E1:E1000)))),TRUE,FALSE)
Returns false even when all conditions become true via manual input.

Statement should check if:
Due Date (I column) is past Today

Fulfillment Date (O column) is empty
There is a release date (E Column)

In the simplest terms, If order is late, if the order hasn't been fulfilled, and if there is a PO release date then the formatting should take place.

If all return true it should format another cell. However no matter the compliance with the formula it does not format.
Any help would be appreciated.

Answer 1

Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 2

>Do you want to apply this to all cells in rows 1 to 1000 in a column? If so, make sure that those cells are selected when you create the rule, and that the cell in row 1 is the active cell in the selection. Change the formula to

AND(I1<TODAY(), O1="", E1<>"")

This insert has now broken the total formula. All cells were highlighted at the time of making the rule. Thanks for the suggestion though.

Answer 3

Do you want to apply this to all cells in rows 1 to 1000 in a column? If so, make sure that those cells are selected when you create the rule, and that the cell in row 1 is the active cell in the selection. Change the formula to

AND(I1<TODAY(), O1="", E1<>"")