Office Solutions

How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel

Finding the top and bottom items in an Excel worksheet is  very ordinary in your work. And in this article, we will use the conditional formatting to quickly achieve this task. In your Excel worksheet, you will sometimes need to find the top n items or bottom n items. If those cells are not in a column or in a row, you cannot sort values. Hence, it is very difficult for you to find out all those cells manually. But in Excel, you can use the conditional formatting to finish this task. Now...

Read more »

6 Main Causes for Data Corruption in MS Access

In this article we look at several common causes which can induce data corruption in an Ms Access database Incidents of Data Corruption in MS Access databases are a fairly common occurrence. Corruption in Access Databases can occur due to several reasons that include both software and hardware related issues.  It is difficult to do away with corruption of data or to find its cause, once it has occurred; therefore it is always better to make attempts to avoid corruption of Access databases....

Read more »