标签：conditional formatting
-
A Funny And Useful Conditional Formatting Trick Sharing
In the previous tutorials, we have mentioned the use of the Conditional Formatting function many times. I don’t know whether you have mastered it. But, today I am going to share with you an interesting technique. Let’s take a look at the effect first. Firstly, we need to type =LARGE(C2:C14, F2) in cell F3 and […]
-
Useful Excel Tricks for Conditional Formatting
As we know that Conditional Formatting can easily spot trends and patterns in your data using bars, colors, and icons to visually highlight important values. But in fact, many people still ignore that conditional formatting is a very useful tool. So today, Sandra would share several tricks for using Conditional Formatting. Highlight Duplicate Data Select […]
-
How To Create A Random Drawing In Excel
You should often see lottery draws in some TV programs, it randomly draws one from a large number of numbers. Today, we will use Excel to make a simple random drawing , which is very simple to create. If you do a activity about random drawing in the future, you can also use it. ok, […]
-
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 […]
