Office Solutions

How to Format Cells with Color Scales in Your Excel Worksheet

In an Excel worksheet, you may need to format certain cells to make them different from others. Here we will introduce the method of using the color scales to fulfill this task. Sometimes in your Excel worksheet, you will format cells according to their values. For example, in the image below, now we need to format the cells according to the sales volume. And instead of formatting cells manually, now you can use the feature of color scales in Excel. Use Color Scales Select the...

Read more »

How to Auto Create New Tasks When Receiving Specific Emails in Outlook

Someone hopes that Outlook can create new tasks automatically when specific emails land into their mailbox. But Outlook doesn’t offer this feature by default. If you have this wish, you still can achieve it by the method introduced in this article. Outlook has no native support to automatically create new tasks when receiving specific emails. However, you still can realize it with the help of rules and VBA. If you are interested in this capability, please read on. The followings are...

Read more »

How to Use the AutoForm Wizard to Create a New Form in MS Access

In this article we introduce you to the AutoForm Wizard in Ms Access and showcase how easy is it to create forms with it. The AutoForm Wizard in MS Access is one of the handiest tools in the application. AutoForm refers to Automatic Forms that can be created in MS Access. As the name suggests, AutoForm allows us to automatically create forms for any given query or table. Through AutoForm we can get a simple data entry within seconds; this will be based on our selected table or query. This...

Read more »