countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 765
Hello friends, hope all is well!
Please help me adjust the code below here.
I want the code to be applied on:
“each row group”.
Thank you very much!
Please help me adjust the code below here.
I want the code to be applied on:
“each row group”.
Thank you very much!
Code:
Sub FormatTop10Items()
With Selection
.FormatConditions.Delete
.FormatConditions.AddTop10
.FormatConditions(1).TopBottom = xlTop10Top
.FormatConditions(1).Value = 1
.FormatConditions(1).Percent = False
.FormatConditions(1).Interior.Color = RGB(210,236,182)
End With
End Sub
Last edited: