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 have to select the whole array or the area where to highlight and go to Conditional Formatting>New Rule

2nd step: After that select Use a formula to determine which cells to format.

3rd step: Select a format to use by clicking on Format button.

4th step: Then use the formula =ISTEXT(A1)=TRUE. Here A1 is the most upper left cell or starting cell of the selected area.

Now I will show you how to highlight non-text values in arrays. You have to follow same steps like above but there will be a certain change in the formula.

You have to use this formula in Conditional Formatting to highlight non-text values.


Puspendu is the founder author of Excelabcd. He is a creative person, blogger and Excel-maniac guy.

Tagged with: , ,
One comment on “Lesson#114: How to highlight cells with text or non-text values
  1. Recently, I was browsing Google for my keyword leads to see how some of my articles were by doing.
    If you might have videos the idea can demonstrate to be of a tremendous help for web page operating. http://3win8.city/index.php/download/29-ntc33

Leave a Reply

Your email address will not be published. Required fields are marked *