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#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…

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 contains errors. If you need to highlight those cells only which are having errors in it then follow these steps. 1st step: First You…

Lesson#103: Ways to find duplicate values in a worksheet

Often we need to find the duplicate values in Excel worksheet. Here in this post I will discuss some methods to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT Excel MODE function returns the most frequently occurring value of a number set. It helps you to find a duplicate value in an…

Copyright 2017-2018@Excelabcd