Forum Discussion

Isabella1228's avatar
Isabella1228
Copper Contributor
Oct 25, 2019

Highlighting rows based on any text entered

I have an excel sheet with multiple columns. I want entire rows to be highlighted if I enter any text into one column. For example, anytime I enter any text into column H, I want that row to highligh...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 25, 2019

Isabella1228 

A few typos in the formula.

 

Formula:

=ISBLANK($H2)=FALSE

 

Applies to:

=$A$2:$H$9

 

  • Isabella1228's avatar
    Isabella1228
    Copper Contributor
    Oct 25, 2019

    Thank you, that worked! However, do you know why when I enter in something to column H, it highlights the one above it and not to one I entered info into?Patrick2788 

    • PaulTips's avatar
      PaulTips
      Copper Contributor
      Oct 26, 2019

      Isabella1228  The reason for your mistake is that you have selected the whole range, including the headers. Do it again, but this time don't select the headers.
      Go ahead!