Some blank cells in a worksheet are actually not empty. But their existence will make you confused. Therefore, you need to find those non-empty cells in your Excel worksheet.
There are many conditions that a cell will be non-empty while the content in it is invisible. For example, a formula will return null value, the font color in the cell is the same as the fill color, or the invisible values that returned by VBA macros. All those reasons can make the content invisible. But actually those...
Read more »
Someone wants to highlight the emails depending on their ages, namely how long the emails have been in their mailbox. Actually it is just based on the received date. This article will introduce a quick and easy method.
Many Outlook users desire to make specific emails to stand out. Undoubtedly, the best way is to color code the emails by conditional formatting rule. Here we will take the following case as an example. A user is afraid that Outlook auto-archive will remove useful items without...
Read more »
Securing Ms Access databases with passwords has become the norm. In this article we look at how we can encrypt and password protect an Ms Access database.
The database password option available in MS Access does not just put a password on your database to protect it, but also encrypts all the records contained in a database. In other words it makes it nearly impossible via normal means to make changes in the database or to access the database without entering the password and decrypting it....
Read more »
