Excel IF formula needed

[brose99]

I need an excel formula that depends on the results in a column of cells, and changes the color of a certain cell if that cell's result is greater than a certain threshold

Ex:

A B C D
1 18%
2 15%
3 21%
4 25%
5 12%
6 20%

How do I write a formula that changes the cell color if any result in Column A is >= 20%?

Thanks in advance.

 

[brose99]

Nevermind. Conditional Formatting was the answer.

 

[Lilliabeth]

You can't change color using an IF function in a cell.

You can use conditional formatting, though.

Format > Conditional formatting
Choose 'Formula is' and enter this in the box:
=MAX(A1:A6)>=20%
Click the little format button, go to the Patterns tab and pick your color. Say OK twice.

 

[Lilliabeth]

Glad to hear you figured it out.
I answered this question:

How do I write a formula that changes the cell color if any result in Column A is >= 20%?

Not this one:

changes the color of a certain cell if that cell's result is greater ...