Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight highest figures
Is there a macro I could use to find the highest figure in a column and make
it bold? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight highest figures
Use conditional formatting.
See 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) "Mamabear" wrote in message ... Is there a macro I could use to find the highest figure in a column and make it bold? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight highest figures
If you really want a macro then try this worksheet code:-
Sub highlightmaximum() Dim rcell As Range Dim Myrange As Range Dim maxval As Variant Set Myrange = Range("A1:A100") '<Change to suit maxval = Application.WorksheetFunction.Max(Myrange) For Each rcell In Myrange rcell.Interior.ColorIndex = xlNone If rcell.Value < "" Then If rcell.Value = maxval Then rcell.Interior.ColorIndex = 6 rcell.Font.Bold = True End If End If Next End Sub Mike "Mamabear" wrote: Is there a macro I could use to find the highest figure in a column and make it bold? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight the highest cell in a column | Excel Worksheet Functions | |||
how do i highlight the ten highest numbers in a range? | Excel Discussion (Misc queries) | |||
Highlight highest / lowest number in a row | Excel Discussion (Misc queries) | |||
Highlight highest numbers in a range. | Excel Programming | |||
looking up figures in a column and selecting next highest match | Excel Worksheet Functions |