Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting Max and Min
Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous different ways using cell value and formula but am unable to have just those two values turn to a different color. Usually I'll have several if not all of the numbers change color. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting Max and Min
Say your data are in A1:A10. Select A1:A10, FormatConditional
Formatting... Formula Is: =A1=MAX($A$1:$A$10) Similarly for MIN. HTH Kostis Vezerides On Jun 21, 7:14 pm, Sean E <Sean wrote: Using Microsoft Excel 2000, I'm attempting to make the max value and min value of a set of unique numbers turn a certain color. I've tried numerous different ways using cell value and formula but am unable to have just those two values turn to a different color. Usually I'll have several if not all of the numbers change color. Any ideas? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting Max and Min
http://www.xldynamic.com/source/xld.CF.html#top3
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sean E" <Sean wrote in message ... Using Microsoft Excel 2000, I'm attempting to make the max value and min value of a set of unique numbers turn a certain color. I've tried numerous different ways using cell value and formula but am unable to have just those two values turn to a different color. Usually I'll have several if not all of the numbers change color. Any ideas? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting Max and Min
try:
FormulaIs: =A1=MAX(A:A) FormulaIs: =A1=MIN(A:A) "Sean E" wrote: Using Microsoft Excel 2000, I'm attempting to make the max value and min value of a set of unique numbers turn a certain color. I've tried numerous different ways using cell value and formula but am unable to have just those two values turn to a different color. Usually I'll have several if not all of the numbers change color. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |