Microsoft Excel monitoring sheet

Question

Hi,

I would like to ask some help regarding my excel monitoring sheet.

Pls. see the attached screenshot as reference.

This excel file (Table) is shared among our group for updating.

Column A shows the list of our Reference Orders.

Once the Order goes out in our area, we need to Key-in the "DATE" and "MOVE TO" in columns E and F respectively.

Then, we need to manually delete the Location (PCB) in column C and then highlight the row from A to F with Grey color, and then Save.

So, when someone saves his copy on his PC, it will be updated for the latest status.

This is my question:

Is there a way that when anybody will key-in the "DATE" and "MOVE TO", it will automatically delete the Location "PCB" and then highlight the row from A to F with Grey Color and then Save? (same as the one shown in Row 7).

By the way, the MOVE TO column is normally empty. And it can be filled-up with any TEXT such as, SHIPPING, WAREHOUSE, STOCKS, MRB TEAM,, etc., etc... once we move the Order..

Hopefully, somebody can help me.

Thanks a lot in advance..

Regards,,

Rico.

Answer 1

Yes, in the steps I provided, You need to selected the affected cells. In your case if this is 200 rows, you select $A$2 to $F$201.

The formula "=AND($E2<>"",$F2<>"")" will automatically recompute in this case since the "$" is only applied in the columns E and F but not in the row number.

In the screenshot below, the one in red box will need to be changed based on the number of rows you have.

Answer 2

Yes... I got it now...

It's perfectly working...

Thank you so much for your help..

Best regards (Rico)