# Formulas in conditional formatting

Solved/Closed
Related:

- Formulas in conditional formatting
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Number to words in excel formula - Guide
- Clear formatting in excel - Guide
- Date formula in excel dd/mm/yyyy - Guide

## 4 responses

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Jan 16, 2011 at 08:37 PM

Jan 16, 2011 at 08:37 PM

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.

Hope this clarifies it.

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Jan 17, 2011 at 08:06 PM

Jan 17, 2011 at 08:06 PM

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

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