In Excel, how do I highlight rows containing any of a range of values?

Answer by  LexiP (722)

If you mean emphasizing the values, you click on the beginning of the row you want to highlight and drag it to the last value of said row. There should be a paint fill button, which fills the selected cells with a color of your choice. You can change the color by clicking on the arrow next to the bucket.

Answer by  gerinsam (50)

In order to Highlight rows containing any range of values select the rows and click on the highlight icon from the menu bar.

Answer by  gigo (1706)

You have to define a help column. Put in this column the value for the formula =IF((A1>3) AND (A1