Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to highlight the lowest valued cell in a column in Excel 2003
I want to highlight the the lowest value cell in a column. How do I do this?
I want to highlight the cell only if one cell in the column has this value. Also at the end of all the columns and rows total at the end of each row the number of highlighted cells in that row. If more than one cell in the column has the lowest value do not highlight. The easiest way for me to explain it would be on a golf scorecard if you play golf and are doing a skins game and for each hole you circle the the lowest score for each hole. If there is no lowest score it carries over to the next hole. If on the next hole there is one low score it is circled plus any carry over columns before it would be circled on that same row. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to highlight the lowest valued cell in a column in Excel 2003
We will use conditional formatting with two criteria:
1. the cell must contain the minimum value 2. the value cannot appear more than once Select the top cell in the column, say column B and: Format Conditional Formatting... FormulaIs =AND(B1=MIN(B:B),COUNTIF(B:B,B1)<2) and pick a nice color then copy the format down the column. -- Gary''s Student - gsnu200819 "mapesii" wrote: I want to highlight the the lowest value cell in a column. How do I do this? I want to highlight the cell only if one cell in the column has this value. Also at the end of all the columns and rows total at the end of each row the number of highlighted cells in that row. If more than one cell in the column has the lowest value do not highlight. The easiest way for me to explain it would be on a golf scorecard if you play golf and are doing a skins game and for each hole you circle the the lowest score for each hole. If there is no lowest score it carries over to the next hole. If on the next hole there is one low score it is circled plus any carry over columns before it would be circled on that same row. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to highlight the lowest valued cell in a column in Excel 2
Thank you for the direction.
"Gary''s Student" wrote: We will use conditional formatting with two criteria: 1. the cell must contain the minimum value 2. the value cannot appear more than once Select the top cell in the column, say column B and: Format Conditional Formatting... FormulaIs =AND(B1=MIN(B:B),COUNTIF(B:B,B1)<2) and pick a nice color then copy the format down the column. -- Gary''s Student - gsnu200819 "mapesii" wrote: I want to highlight the the lowest value cell in a column. How do I do this? I want to highlight the cell only if one cell in the column has this value. Also at the end of all the columns and rows total at the end of each row the number of highlighted cells in that row. If more than one cell in the column has the lowest value do not highlight. The easiest way for me to explain it would be on a golf scorecard if you play golf and are doing a skins game and for each hole you circle the the lowest score for each hole. If there is no lowest score it carries over to the next hole. If on the next hole there is one low score it is circled plus any carry over columns before it would be circled on that same row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Lowest value ignoring 0 or blank cell | Excel Discussion (Misc queries) | |||
CF to highlight lowest price in row | Excel Worksheet Functions | |||
highlight highest and lowest cells within a given column in ex | New Users to Excel | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel |