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 »

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 »

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 »

Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …

Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »

Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …

Lesson#92: How to highlight a column value depending upon the other column values Read more »