Conditional Format Question

[medic49]

How do I make my cell shade a certain color? For example, green if >90%, yellow if >70% and red if <70%.

 

[BenMiller]

How about =70%?

LOL ... Just kidding. I know what you mean.

What version of Excel are you using? Highlight the data you want to affect and go to Format>Conditional formatting. Fairly easy to navigate. Excel 2010 even has pre-designed ones that come built-in.

 

[medic49]

LOL I am using 2007

 

[medic49]

Which rule type do I use?

 

[LCTrucido]

Which rule type do I use?

Cell value is (Less Than, Between, or Greater Than).

 

[medic49]

Is it possible to show me? Step by step?

Sorry, new to excel.

 

[T. Valko]

Is it possible to show me? Step by step?

Sorry, new to excel.

Your intervals are not well defined so I'll asume they are:

>=90% = green
>=70% = yellow
<70% = red

Let's assume the cells to format are A1:A10.

Select the *entire* range A1:A10 starting from cell A1.
Cell A1 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:

=A1>=0.9

Click the Format button
Select the Fill 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:


=A1>=0.7

Click the Format button
Select the Fill 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(A1<>"",A1<0.7)

Click the Format button
Select the Fill tab
Select a shade of RED
OK out