Forum Discussion
Tool to check table against 2 other tables in excel
Hi all, I am working on project that checks on stock levels when next daya delivery list is copied in. Company has a SQL server that has all stock information. I have pulled data into excel so now ...
You can use a formula like =ISERROR(B2) where B is your new column for quantities. Set a formatting style (like a fill color) to highlight cells where the formula returns TRUE.