I'm very new to Excel formulas and really struggling. I'm creating a spreadsheet which lists items and their specifications. Eg. column A has the item name, B has the size, C has the file type, D is the due date etc. I want to make sure that if people add an item that they fill out ALL the specs for that item, not leaving any blanks. (There are a couple of columns that can be blank, like the notes column, but most are required.)
Is there a way to make cells mandatory? Or warn when the user tries to save/close the file with missing information? If not, what's the best alternative? I've seen other people suggest using conditional logic to highlight blank cells, but I'm not sure how to limit that to ONLY the rows that contain an item (since the list may grow or shrink with items being removed or added). Any advice appreciated!
Is there a way to make cells mandatory? Or warn when the user tries to save/close the file with missing information? If not, what's the best alternative? I've seen other people suggest using conditional logic to highlight blank cells, but I'm not sure how to limit that to ONLY the rows that contain an item (since the list may grow or shrink with items being removed or added). Any advice appreciated!