Here I will make a formula in Conditional Formatting. This formula will color cells if the cell value is found in another column. For example, I am showing this picture below. If the value is present in column A then …

Lesson#140: Color cells if cell value found in another column – Conditional formatting Read more »

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 »