Try this small macro:

Sub hilight()
For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeComme nts)
If r.Value 0 Then
r.Interior.ColorIndex = 6
End If
Next
End Sub


--
Gary''s Student - gsnu200853


"Devender" wrote:

Want to highlight only those cell which are having comment and their value
is greater than 0