| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
loop thru column and highlight the rows
hi guys, my previous entry probably sounded a bit confusing so heres a simplified version of it. i would like my macro to do the following in the current worksheet. go to column j and loop thru it. if it finds " GR " in the cell, it has to highlight the entire row (belonging to the cell with " GR " in it), if not it moves on till the end of the column j. could u please help me? Thanks so much in advance! mariasa -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726 View this thread: http://www.excelforum.com/showthread...hreadid=557545 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
loop thru column and highlight the rows
Already answered for Maria.
"mariasa" wrote: hi guys, my previous entry probably sounded a bit confusing so heres a simplified version of it. i would like my macro to do the following in the current worksheet. go to column j and loop thru it. if it finds " GR " in the cell, it has to highlight the entire row (belonging to the cell with " GR " in it), if not it moves on till the end of the column j. could u please help me? Thanks so much in advance! mariasa -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726 View this thread: http://www.excelforum.com/showthread...hreadid=557545 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) | |||
| Excel should have row column highlight indicator | Excel Worksheet Functions | |||
| how do I highlight the current row and column | Excel Discussion (Misc queries) | |||
| Highlight Sort Column | Excel Discussion (Misc queries) | |||
| how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) | |||
Linear Mode
