Hi-
I'd like to have cells turn RED via a conditional based on the following:
If the column called CONTAINER # does not have a value entered (EX: HCU1212123) 2 days prior to the column PO CANCEL DATE (ex: 05/20/2013) then the cells turn RED based on a conditional to denote the shipment as late. Basically if a container # is not entered in by 05/18 then cells would turn red and we can consider the shipment as late.
I have tried an IF AND statement with a ISBLANK but it doesn't seem to be formulating the correct end value. I am thinking the data also needs to reference either TODAY's date or the date the CONATINER # information was entered in the spreadsheet.
any help would be much appreciated.
Spreadsheet set up:
I'd like to have cells turn RED via a conditional based on the following:
If the column called CONTAINER # does not have a value entered (EX: HCU1212123) 2 days prior to the column PO CANCEL DATE (ex: 05/20/2013) then the cells turn RED based on a conditional to denote the shipment as late. Basically if a container # is not entered in by 05/18 then cells would turn red and we can consider the shipment as late.
I have tried an IF AND statement with a ISBLANK but it doesn't seem to be formulating the correct end value. I am thinking the data also needs to reference either TODAY's date or the date the CONATINER # information was entered in the spreadsheet.
any help would be much appreciated.
Spreadsheet set up:
CONTAINER # | FREIGHT RELEASE | CUSTOMS RELEASE | SHIPPING COMMENTS | PO START SHIP | PO CANCEL DATE |
HVCD1212123 | 5/19/2013 |