I am currently trying to make a spreadsheet for my company and I need some help.
Is there a way to conditionally format a table in sheet one so if the table is not finished (or cell is left blank) it would show on the next worksheet?
For example I have a incoming product sheet where the inventory needs to be signed and approved. if in the first sheet, the cell for the signature is not filled out, it would show up on the next sheet as a reminder.
My explanation is not great but I am trying to filter out the unfinished rows in a very large collection of data to the next sheet. Is there an efficient way to do so in excel?
Thanks
Bookmarks