raisedwell
New Member
- Joined
- Mar 4, 2010
- Messages
- 22
I have a comprehensive checklist that I would like validate if multiple cells contain a value (*) and then provide a status of "Complete" or "Incomplete at the top of the checklist.
(The goal is to ensure that all questions are answered and none were skipped or left blank.)
Scenario #1 (Singe worksheet)
The cells that I need to validate are specific answers and are not in a range of continuous cells (ex. B2, B3, B4, B5) but rather various specific cells (ex. B2, B5, B9, B11, B22).
Scenario #2 (2 Different Worksheets)
Same as above but the cells span across 2 different worksheets. (ex. Sheet1 & Sheet2)
Thanks in advance.
(The goal is to ensure that all questions are answered and none were skipped or left blank.)
Scenario #1 (Singe worksheet)
The cells that I need to validate are specific answers and are not in a range of continuous cells (ex. B2, B3, B4, B5) but rather various specific cells (ex. B2, B5, B9, B11, B22).
Scenario #2 (2 Different Worksheets)
Same as above but the cells span across 2 different worksheets. (ex. Sheet1 & Sheet2)
Thanks in advance.