| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight MAX Cell Greater Than Zero | Excel Discussion (Misc queries) | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
