Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
If I have four cells, and I want the one with the smallest value change
color automatically. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
Hi,
Select you 4 cells - in my case A1 - A4 then Format|Conditional format Formula is =A1=MIN($A$1:$A$4) Pick a colour and click OK Mike "Smallest value cell change color" wrote: If I have four cells, and I want the one with the smallest value change color automatically. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
You can:
Select the range (say A1:B2) format|conditional formatting (xl2003 menus) formula is: =a1=min($a$1:$b$2) and give it a nice format. Smallest value cell change color wrote: If I have four cells, and I want the one with the smallest value change color automatically. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
Assume the range of cells is A1:D1
Select the range A1:D1 Goto the menu FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN($A$1:$D$1)) Click the Format button Select the style(s) desired OK out -- Biff Microsoft Excel MVP "Smallest value cell change color" <Smallest value cell change wrote in message ... If I have four cells, and I want the one with the smallest value change color automatically. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
I would like to do this same function only I want to grab the three lowest
values. Any ideas? "Smallest value cell change color" wrote: If I have four cells, and I want the one with the smallest value change color automatically. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Compare between cells and choose smallest value
......A.....B.....C.....D
1..22....15....29...30 =SMALL(A$1:D$1,ROWS(A$1:A1)) Copy down a total of 3 cells. Note that if there aren't at least N numbers in the range you'll get errors. This formula makes sure there are enough numbers: =IF(COUNT(A$1:D$1)=ROWS(A$1:A1),SMALL(A$1:D$1,ROW S(A$1:A1)),"") -- Biff Microsoft Excel MVP "jerminski73" wrote in message ... I would like to do this same function only I want to grab the three lowest values. Any ideas? "Smallest value cell change color" wrote: If I have four cells, and I want the one with the smallest value change color automatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 columns and choose one and enter answer in third column | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
How do I compare two lists and choose the items that are in both? | Excel Worksheet Functions | |||
COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT | Excel Discussion (Misc queries) | |||
Ranking cells largest to smallest | Excel Discussion (Misc queries) |