Want to highlight only those cell which are having comment and their value is greater than 0
D Devender May 18, 2009 #1 Want to highlight only those cell which are having comment and their value is greater than 0
G Gary''s Student May 18, 2009 #2 Try this small macro: Sub hilight() For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeComments) If r.Value > 0 Then r.Interior.ColorIndex = 6 End If Next End Sub
Try this small macro: Sub hilight() For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeComments) If r.Value > 0 Then r.Interior.ColorIndex = 6 End If Next End Sub
