Conditional Formatting Problem!!!

[ksweat]

I can't figure this out, I know how to use conditional formatting to highlight a row, but some of these overlap:

Column D is between 0 and 30, turn green
Column D is between 31 and 45, turn yellow
Column D is greater than 45, turn red

The issue I'm running into is, Column D will always be greater than 0, so they all turn green no matter what. Any suggestions?

 

[T. Valko]

I can't figure this out, I know how to use conditional formatting to highlight a row, but some of these overlap:

Column D is between 0 and 30, turn green
Column D is between 31 and 45, turn yellow
Column D is greater than 45, turn red

The issue I'm running into is, Column D will always be greater than 0, so they all turn green no matter what. Any suggestions?

What version of Excel are you using?

 

[ksweat]

2007

 

[abmati]

You have to do it 3 times as under, set color format as you want:
1. Format only cells that contains: Cell Value: Less than 30
2. Format only cells that contains: Cell Value: Between 31 and 45
3. Format only cells that contains: Cell Value: Greater than 45

Regards

 

[T. Valko]

2007

Try this...

Let's assume the range to format is D1:D10.

Select the *entire* range D1:D10 starting from cell D1.
Cell D1 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>Manage rules

New rule
Use a formula to determine which cells to format
Enter this formula in the box below:
=AND(COUNT(D1),D1>=0)
Click the Format button
Select the Patterns tab
Select a shade of GREEN
OK>OK

New rule
Use a formula to determine which cells to format
Enter this formula in the box below:
=AND(COUNT(D1),D1>=31)
Click the Format button
Select the Patterns tab
Select a shade of YELLOW
OK>OK

New rule
Use a formula to determine which cells to format
Enter this formula in the box below:
=AND(COUNT(D1),D1>45)
Click the Format button
Select the Patterns tab
Select a shade of RED
OK out