Author: Pushpendu Roy Karmakar

Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

By Posted on Posted in Excel Features, Excel Funtions, Excel general tips Tagged with

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 »

By Posted on Posted in Excel Funtions, Excel Tricks Tagged with , ,

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 »

By Posted on Posted in Excel Funtions, Excel Tricks Tagged with , ,

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 »