Smallest value in multiple ranges

[crazyeyeschase]

Needing to search for and highlight the lowest value in columns I, K, and N.

I know it is as simple as selecting the three columns as the range (or even cell I4, K4, and N4) then finding the lowest value in the three cells and highlighting it and then moving to the next row.

I have been playing around but just cannot get things figured out any help will be very helpful.

 

[Nishant94]

Use conditional formatting to highlight the lowest value with some colour.

Use the following formula in conditional formatting to highlight it with some colour with I1 being the active cell:

=MIN(MIN(MIN($I:$I),$K:$K),$N:$N)=I1

For more detail on conditional formatting visit https://support.office.com/en-us/ar...rmatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

 

[crazyeyeschase]

I have not been able to get the conditional formatting to work is their any tricks?

 

[crazyeyeschase]

This is the closest Ive gotten to what i want on a test document.

Sub search()
Dim rng As Range
Dim rngData As String
Dim vValue As Variant
Dim rngRow As Range
Dim lngCol As Long
Dim rngAdd As Range


rngData = "I1, K1, N1"

Set rng = Range(rngData)

vValue = Application.WorksheetFunction.Min(rng)

For Each Row In rng.Rows
    If Application.WorksheetFunction.CountIf(Row, vValue) > 0 Then
        lngCol = Application.WorksheetFunction.Match(vValue, Row, 0)
            
        Set rngAdd = rng.Rows.Cells(lngCol, 1)
    
        rngAdd.Select
        
        With Selection
            .Interior.Color = RGB(255, 255, 0)
        End With
        Exit Sub
    End If
Next
End Sub

However this only does one range {A1:E1} not something like (A1, C1, and F1)

Also when it highlights it highlights the cell in column A.

So lets say if the lowest number in the range of A1:E1 is in cell C1 it will highlight cell A3.

It also will not go to say the next row.

Please any help would be great.
So l