want to highlight cell which having comment & greater than 0
Want to highlight only those cell which are having comment and their value
is greater than 0 |
want to highlight cell which having comment & greater than 0
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 |
All times are GMT +1. The time now is 08:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com