Forum Discussion
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 highlight. I know how to have rows highlight due to a specific text, but I want as I enter in text to column H, it to highlight that row.
5 Replies
To highlight the content of a whole row you can follow these simple steps:
1) Select the range of cells you want to highlight.
2) Among the Conditional Formating options, choose "New Rule"
3) Now, select the last of the options: "Use a formula to ..."
4) The formula must be a logical one, that is, it must return TRUE or FALSE.
To write the formula, you must take as an argument the first cell on the top left of the range.
For example, = ISBLANK ($ H2) = FALSE
(This formula will return TRUE only when the cell is complete) Notice that there is a mixed reference: The column is fixed while the row is free! This allows the condition to apply to all rows in the selected range.
5) Then, you can configure the formatting options as you wish.I hope this helps!
PaulTips I did this but it didn't work, I am not sure where I went wrong.
