Task is to highlight all the rows which have minimum quoted rate for a particular item:
For eg: for item 101, Rs. 2000 is the minimum quote so highlight all the rows which contains quoted rate of 2000 for item 101.
Same is the case for Item 102.
For getting it done I have recorded this piece of code
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
Selection.FormatConditions(1).StopIfTrue = False
At the end of the code I see that only the second row is getting highlighted but the eighth row, which contains the lowest quoted rate for item 102, is not getting highlighted.
Can someone help??