Having 10 cells with the highest number turn color
 

I have created a spread sheet that keeps track of the number of mistakes a
file being reviewed has. The person using this sheet wishes to have the top
10 areas that have the most mistakes turn yellow or some other color so they
know to focus on improving these areas; is there any way to do this?

Having 10 cells with the highest number turn color
 

You can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message ...
I have created a spread sheet that keeps track of the number of mistakes a
file being reviewed has. The person using this sheet wishes to have the top
10 areas that have the most mistakes turn yellow or some other color so they
know to focus on improving these areas; is there any way to do this?

Having 10 cells with the highest number turn color
 

I used your "Highest 4 numbers in a range" formula but substituted 10 for 4
and it did not work. Instead it just randomly picked cells to highlight
yellow. Did I do something wrong? This is the formula I used:

=AND(ISNUMBER($E10),$E10LARGE($E$10:$E$88,10))

"David McRitchie" wrote:

You can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message ...
I have created a spread sheet that keeps track of the number of mistakes a
file being reviewed has. The person using this sheet wishes to have the top
10 areas that have the most mistakes turn yellow or some other color so they
know to focus on improving these areas; is there any way to do this?

Having 10 cells with the highest number turn color
 

The example had = (greater than or equal) not just (greater than)
of course it only works if there are no duplicate numbers in the high values.

Read the top part of the web page the cells that get the color
must be selected beforehand, and the formula is based
on the active cell, so you should have had cell E10 or
any cell on row 10 (based on $E10) as the active cell
so that if the cell in E10 is a high number all cells that
were in the selection when entering C.F. that are on that
row will be color coded.

To color columns E&F based on a high value in column E

Select E10:E88 since that is the range you are testing
Cell E10 will be your active cell and will be colored accordingly.
=AND(ISNUMBER($E10),$E10=LARGE($E$10:$E$88,10))

Cell E11 will be tested and the formula adjusted from the one
used in Cell E10 so that it effectively would be tested with
=AND(ISNUMBER($E11),$E11=LARGE($E$11:$E$88,10))
even though there is only one actual conditional formatting formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message ...
I used your "Highest 4 numbers in a range" formula but substituted 10 for 4
and it did not work. Instead it just randomly picked cells to highlight
yellow. Did I do something wrong? This is the formula I used:

=AND(ISNUMBER($E10),$E10LARGE($E$10:$E$88,10))

"David McRitchie" wrote:

You can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message
...
I have created a spread sheet that keeps track of the number of mistakes a
file being reviewed has. The person using this sheet wishes to have the top
10 areas that have the most mistakes turn yellow or some other color so they
know to focus on improving these areas; is there any way to do this?

Having 10 cells with the highest number turn color
 

Maybe I'm not being clear in what I'm trying to do. Columns A-D (these
columns are merged together) list forms in binders that should be completed
and what on each form should be completed, this goes from row 10 to row 88.
Column E is a formula column that calculates the total from columns F-AN.
Columns F-AN are the binders they review in a month (35 columns for 35
binders) and used to track how many mistakes are on any given form.

A B C D E F G H I J...
....AN
10 Signed into QA late 6 1 1 1 1 1
11 HCSIS not... 7 1 1 1 1 1
....
87 Incorrect 23 1 7 4 1 10
88 Incomplete 9 1 1 1 1 1

They would like to have column E highlight the 10 largest numbers so that
they can look over to row A and see that maybe too many binders are being
signed in late or a certain form is being turned in incomplete a lot.

Does that make more sense? The formula you are giving me is not doing this.
Perhaps I am trying to use the wrong formula all together. Can someone
please help me?
"David McRitchie" wrote:

The example had = (greater than or equal) not just (greater than)
of course it only works if there are no duplicate numbers in the high values.

Read the top part of the web page the cells that get the color
must be selected beforehand, and the formula is based
on the active cell, so you should have had cell E10 or
any cell on row 10 (based on $E10) as the active cell
so that if the cell in E10 is a high number all cells that
were in the selection when entering C.F. that are on that
row will be color coded.

To color columns E&F based on a high value in column E

Select E10:E88 since that is the range you are testing
Cell E10 will be your active cell and will be colored accordingly.
=AND(ISNUMBER($E10),$E10=LARGE($E$10:$E$88,10))

Cell E11 will be tested and the formula adjusted from the one
used in Cell E10 so that it effectively would be tested with
=AND(ISNUMBER($E11),$E11=LARGE($E$11:$E$88,10))
even though there is only one actual conditional formatting formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message ...
I used your "Highest 4 numbers in a range" formula but substituted 10 for 4
and it did not work. Instead it just randomly picked cells to highlight
yellow. Did I do something wrong? This is the formula I used:

=AND(ISNUMBER($E10),$E10LARGE($E$10:$E$88,10))

"David McRitchie" wrote:

You can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"artemis1027" wrote in message
...
I have created a spread sheet that keeps track of the number of mistakes a
file being reviewed has. The person using this sheet wishes to have the top
10 areas that have the most mistakes turn yellow or some other color so they
know to focus on improving these areas; is there any way to do this?

Having 10 cells with the highest number turn color
 

What does it do instead of working?
Email me and I will send you my test worksheet. (sheet92)


---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"artemis1027" wrote in message ...
Maybe I'm not being clear in what I'm trying to do. Columns A-D (these
columns are merged together) list forms in binders that should be completed