Office Solutions

4 Easy Tips to Change the Color of Comment Balloons or Texts in Your Word Document

In this article, there are 4 easy tips for you to change the color of comment balloons or texts in your Word document. By and large, the color of comment balloons in document is randomly assigned by Word according to the editing author. Similarly, the comment text color is by default set in black. Nevertheless, we still can apply some tricks to change the default color. Tip 1: Apply Custom Color for Comment Balloons It’s a popular knowledge that Word distributes color to comment balloons...

Read more »

2 Quick Ways to Get the Difference between Two Dates or Times via Word VBA

In this article, we want to present you 2 quick and efficient ways to get the difference between 2 specific dates or times via Word macros. To calculate the days or time left between 2 concrete dates or times is of no difficulty. You can either do the math by yourself or get a date or time duration calculator. And here we want to demonstrate you the 2 macro ways which enable you to get the date or time difference in Word. Following are the detailed steps: Get the Date Difference First...

Read more »

8 Common Formula Errors in Excel

Excel formulas in Excel is able to help you finish some rather complex tasks. But you will certainly meet with formula errors in Excel. In this article, we will show you the 8 formula errors in Excel. There are many reasons that will cause formula errors in Excel. For example, you are not familiar with the rule of a certain function, or there is something wrong with the referred cells. In the following parts, we will demonstrate the 8 formula errors with some examples. 1.   ...

Read more »