Lesson#118: Format only cells that contain

Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option make many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then select Format only cells that contain This feature allows you to Highlight Cell values within a…

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 which will split up all characters of the text vertically in a column. Now I have…

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 name for range, reference or formula to work in the spreadsheet easily. Above picture shows a simple data table of student marks, name. For the easiness of work we…

Lesson#115: Information functions with Conditional Formatting

Here I will share a 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 specified type of values among an array. ISBLANK function highlights blank cells among an array of values. ISERR function highlights errors among an array of values. ISERROR function highlights errors among an array of…

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 array which contains both text and non-text values. What you have to do when you need to highlight only text values. You have to follow some steps then. 1st step: First You…

Copyright 2017-2018@Excelabcd