- Dec 2, 2016
Hello, I have a command button on Sheet 1 which when clicked will ask for a password to unhide Sheet 2. Now on Sheet 1, I have few cells that I have made mandatory to other users to complete. There is conditional formatting with background red color for those mandatory to complete cell. When empty, they are red and if text entered then background disappears. Now, is there any way, that the command button can refuse to unhide Sheet 2 unless all the mandatory fields with red background are complete. It will only unlock when it does not find any conditional formatting present on Sheet 1????