Short Tips#0068: How to highlight blank cells only
Lesson#116: How to name a range in excel
This post will teach you the basic concept of Name Manager. Here I will show how to name a range in excel. You can also create names for the range, reference, or formula to work in the spreadsheet easily. Above …
Lesson#115: Information functions with Conditional Formatting
Here I will share general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight the specified types of values among an array. ISBLANK function highlights blank cells among an array of …
Lesson#115: Information functions with Conditional Formatting Read more »
Lesson#114: How to highlight cells with text or non-text values
We will discuss how to highlight text values or non-text values among an array. In the above picture, I have shown an example of the array which contains both text and non-text values. What do you have to do when …
Lesson#114: How to highlight cells with text or non-text values Read more »
Lesson#113: How to highlight cells with errors in it
I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them, I have some cells which contain errors. If you need to highlight those cells …
Lesson#113: How to highlight cells with errors in it Read more »
Lesson#112: Calculate the match percentage of text which matches another text.
Here I will discuss an interesting formula. With this formula, we can calculate the percentage of a text matching another text. In the above picture, I have shown two cells. The first cell has a long text value and the …
Lesson#112: Calculate the match percentage of text which matches another text. Read more »