Discussion Locked

Excel NOT Overjump a Cell in A worksheet

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are preparing a worksheet for the annual achievement in our department. We are looking for a way to make sure that all cells within that should not be left blank.

Is there any way to make Excel look after this job.

3 replies

by dklippert

Select the cells, then go to Format>Conditional Formatting.
Choose ?Formula is? and enter =ISBLANK(A1).
Now choose a Format such as Red on the Patterns tab.
If you want to enforce a particular kind of entry, such as text or number range, you can use Data>Validation, but that won?t warn about empty cells.

by wandsnl

Depending on how much information needs to be entered, you could also write a VBA macro to handle the user input. In this way you can check that all fields have some data input before the information is transferred into the spreadsheet. If this is too much, what about a macro that checks the relevant cells for blanks and then goes to them one by one. Just an idea.

This discussion is closed to new replies.