Tags：conditional formatting
-
How to Highlight All the Nonworking Days in Excel Spreadsheet
If you entered a series of dates into Excel spreadsheet, and want to highlight all the nonworking days. Do you have to pick out the weekends manually? In my previous post, I’ve introduced some uses of the powerful Conditional Formatting. It enables you to apply a format to multiple cells that meet the specific criteria. […]
-
25 Microsoft Excel Tips for Beginners Who Work at Office
For an office worker, it’s very important to grasp some commonly used Excel skills to process the data in a spreadsheet. Only in this way they can save the time to do more constructive work and improve themselves. So, how to use Microsoft Excel smartly to boost the working efficiency? In this post I collected […]
-
How to Use Conditional Formatting to Shade the Specified Data in Excel
The so-called Conditional Formatting, is a practical feature with which Excel can set the format of the corresponding data. One example is that when you want to highlight some specified data in a spreadsheet, you can use Conditional Formatting to shade them automatically avoiding a lot of manual operations. First, select the range of cells […]
