Identifying Row with Largest Value in G : FormatConditions « Excel « VBA / Excel / Access / Word






Identifying Row with Largest Value in G

 
Sub FindMinMax()
    FinalRow = cells(Application.Rows.count, 1).End(xlUp).row
    With range("A2:I" & FinalRow)
        .FormatConditions.delete
        .FormatConditions.add Type:=xlExpression, Formula1:="=RC7=MAX(C7)"
        .FormatConditions(1).Interior.ColorIndex = 4
        .FormatConditions.add Type:=xlExpression, Formula1:="=RC7=MIN(C7)"
        .FormatConditions(2).Interior.ColorIndex = 6
    End With
End Sub

 








Related examples in the same category

1.all the ranges that have conditional formatting set up
2.Setting Up Conditional Formats in VBA
3.generates a three-color color scale in range A1:A10:
4.Specifying an Icon Set
5.Specifying Ranges for Each Icon
6.Using Two Colors of Data Bars in a Range
7.Add Crazy Icons
8.highlight cells above average:
9.highlight cells below average:
10.Formatting Cells in the Top 10
11.Formatting Cells in the Bottom 5
12.Formatting Cells in the Top 2 percent
13.Formatting Duplicate Cells
14.Formatting Unique Cells
15.Formatting Cells whose value between 10 and 20
16.highlights all cells that contain a capital letter A
17.highlights all dates in the past week:
18.creates the formatting shown in column A
19.Highlight the Entire Row for the Largest Sales Value
20.Using the New NumberFormat Property