Tag: CONDITIONAL FORMATTING

Short Tips#0070: How to highlight error cells

Tagged with:

Short Tips#0069: How to highlight blank cells

Tagged with:

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

Tagged with:

Short Tips#0068: How to highlight blank cells only

Tagged with: ,

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.

Tagged with:

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

Tagged with: , ,

Short Tips#0067: How to highlight cells with errors

Tagged with: ,

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

Tagged with: ,

Short Tips#0041: Find duplicates or unique with Conditional Formatting

Tagged with:

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

Tagged with: , , , ,
Top