I have a spreadsheet where I track my daily orders. I include the sales order number, delivery order number, customer code, order total, then I have checkboxes for delivery or pickup, terms or COD, etc.

We frequently have customers with terms have their orders go on credit hold for review for someone at corporate to release.

What I have been trying to figure out is when I check the box for terms in Column H, I want a Yes/No alert pop-up that asks if the order is on hold. If the order is on hold and I click "Yes" I want the sales order number cell in Column B to change to yellow.

When I am entering and recording orders, I typically first check the terms or COD boxes, then enter the sales order number. So, ideally, I want to have conditions in place where if the terms box is checked and then a number is entered in the sales order cell and I hit enter, the alert will then pop-up and clicking yes will change the color of the cell I just entered the number in.