Short Tips#0069: How to highlight blank cells
Author: Puspendu Roy Karmakar
Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#118: Format only cells that contain Conditional Formatting
Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option makes many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then …
Lesson#118: Format only cells that contain Conditional Formatting Read more »
Lesson#117: How to split up characters of text in excel
Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula …
Lesson#117: How to split up characters of text in excel Read more »
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 »
