MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Error messages


Posted by Stephen Ellis on July 31, 2001 6:55 AM

If I have a a if statement and the answer comes back false is there anyway I can disable all the cells in the rest of the worksheet? If this is not possible can I shade all the cells in the rest of the worksheet in red? If either of these are possible your help would be greatly appreciated!!

Thanks


Posted by IML on July 31, 2001 7:49 AM

There are probably more secure way with VBA, but you could try data validation as follows

Assume your true false is in cell A1. Go to Highlight the error you want to protect.
Go to Data Validation and change the allow field to Custom
Type in the formula A1=True. You can also put in some custom error and input messages here.
Be aware that people can still use paste to get around this.

You can also use conditional formatting on the cells. Highlight your cells, choose conditional formatting from the Format menu, enter the formula
=$A$1=FALSE
and select your format. Good luck

Good luck

Posted by IML on July 31, 2001 7:52 AM

attempt to fix typos.