Formulas in conditional formatting

[Solved/Closed]
Report
-
 Puzzled -
Hello,

In Excel 2010, I'm trying to color entire rows in a spreadsheet based on values in a certain column. I have been able to do this for numbers either above or below a value, but I haven't been able to figure out how to color a row for a cell value between 2 numbers. For example, I want a row to turn green if the value in column J is a value between 25 and 49.

Can anyone help with this?

n

4 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
there is a choice "the cell value is" between. use that.
I believe that will only change the cell that has that number. I want to change the color of the entire row based on a cell value. I have been able to use the "Use a formula to determine which cells to format function to color rows based on being either =, >, < a value but I haven't found a formula that will allow me to check for valiues between a high and low number.

Hope this clarifies it.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
supposed your cell is E1 (column E row 1) if it contains between 25 and 49 the whole row no. 1 must be colored red(or some color)

1.select(highlight) the whole row 1
2. in conditional formatting choose "the formula is" in the left hand side window
3. on the right side type this formula
=AND($E1>=25,$E1<=49)
click format and choose pattern and choose your color
click ok and again click ok

now type some number between 25 and 49 in E1 and see what happens
You got it! I just couldn't get the formula right.

Thank you very much.