J JEC8878 New Member Jun 18, 2024 #1 Hi - is it possible to set up a spreadsheet so that if i have text in column C then the corresponding cells in columns B,D,E,G and H MUST be filled in See attached spreadsheet Attachments Test sheet.xlsx 82.2 KB · Views: 10
Hi - is it possible to set up a spreadsheet so that if i have text in column C then the corresponding cells in columns B,D,E,G and H MUST be filled in See attached spreadsheet
P Peter Bartholomew Well-Known Member Jun 18, 2024 #2 You can detect the error and use conditional formatting to highlight errors or you could use a Boolean criterion to block all calculation until the user complies. Ultimately though, there is nothing a spreadsheet can do to enforce your rule.
You can detect the error and use conditional formatting to highlight errors or you could use a Boolean criterion to block all calculation until the user complies. Ultimately though, there is nothing a spreadsheet can do to enforce your rule.