Tag: CONDITIONAL FORMATTING
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#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 »
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 contain errors. If you need to highlight those cells …
Lesson#113: How to highlight cells with errors in it Read more »
Lesson#103: 4 Ways to find duplicate values in a worksheet
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 »
Lesson#92: How to highlight a column value depending upon the other column values
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 »