| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight the highest cell in a column
Column B5 - B25 contain a set of numbers. How can I highlight the cell with
the highest number? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight the highest cell in a column
1. Select the cell/Range (say B5:B25). Please note that the cell reference B5
mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =B5=MAX($B$5:$B$25) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK Incase you are using 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format If this post helps click Yes --------------- Jacob Skaria "exhub58" wrote: Column B5 - B25 contain a set of numbers. How can I highlight the cell with the highest number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i highlight the ten highest numbers in a range? | Excel Discussion (Misc queries) | |||
| 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 | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
Linear Mode
