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: 17
Default Yet another conditional formating question (Excel 2003)

Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.
 
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
Conditional Formating (?) question mmills421 Excel Discussion (Misc queries) 12 May 8th 08 10:00 PM
CONDITIONAL FORMATING QUESTION Megan Excel Discussion (Misc queries) 3 November 15th 07 02:52 PM
Conditional Formating Question carl Excel Worksheet Functions 4 March 10th 07 11:30 AM
Another Conditional Formating Question RalphSE Excel Worksheet Functions 2 March 16th 06 07:05 PM
Conditional Formating Question terri Excel Discussion (Misc queries) 3 November 27th 05 02:01 AM


All times are GMT +1. The time now is 02:36 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"