LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change the font of highest number in a range of cells Herman New Users to Excel 2 January 23rd 07 05:32 PM
I want to count the highest number of equal cells fiur Excel Worksheet Functions 6 October 16th 06 04:47 AM
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates John Excel Worksheet Functions 3 August 11th 06 04:34 AM
how to count number of cells in a color ? Francisco Excel Discussion (Misc queries) 4 September 25th 05 01:09 PM
How do I find highest number in a row and change color? pamstolen Excel Worksheet Functions 3 January 18th 05 12:35 AM


All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"