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?