Formulas in conditional formatting
Solved/Closed
Related:
- Formulas in conditional formatting
- Spreadsheet formulas - Guide
- Little alchemy formulas - Guide
- Number to words in excel formula - Guide
- How to clear formatting in excel - Guide
- Marksheet format in excel - 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
