Excel 2007 : Conditional formatting-down for any greater or lesser value to change

**Workerofwork** · 06-21-2010, 08:04 PM

Hello,
This might be something simple I cannot solve. I am learning excel for work and I ran into a request I cannot make. My boss asked me to make a conditional format that would change a couple cell's colors all at once based on a value of another cell. Example, if one cell reached over 45% a couple others would all change green. Well I got that one without much trouble. Pretty much I got the formatting down for any greater or lesser value to change but not a between. I can't see to find out a way to make a couple cells change color all at once based on a value between 25% - 30%. Any help would be appreciated. Thanks

**shg** · 06-21-2010, 08:21 PM

Select Formula is from the dropdown, =AND($A$1>=25%, $A$1<=30%).

The details of where the dollar signs appear depend on whether you're formatting a group of cells in a single row, or single column, or random cells.