Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a macro
Hi All, Hope someone can help with a macro. Want to highlight cells depending on a value returned by a vlook up formula. If a value of 6 (could be anything from 2 to 50) is returned in cell A100 (could be any column, cell) then highlight the next 6 cells down or up depending on which row value is in (alternating, first row upwards, second downwards, third upwards and so on). Each column will only need to be highlighted up or down. New to excel don’t know if this is straight forward or not. Hope I’ve explained myself clearly, any assistance would be appreciated, really, been at it all day. Cheers -- JAZZNAURA ------------------------------------------------------------------------ JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961 View this thread: http://www.excelforum.com/showthread...hreadid=572852 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a macro
For i = 1 to Cells(100,Columns.Count).End(xlToLeft).Column
If Cells(100,i).Value =2 Or Cells(100,i)Value < 50 Then Cells(100,i).Offset(-3,0).Resize(6).Interior.Co9lorindex = 6 End If Next i bit of a guess as I am not sure why row is variable when you state row 100. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JAZZNAURA" wrote in message ... Hi All, Hope someone can help with a macro. Want to highlight cells depending on a value returned by a vlook up formula. If a value of 6 (could be anything from 2 to 50) is returned in cell A100 (could be any column, cell) then highlight the next 6 cells down or up depending on which row value is in (alternating, first row upwards, second downwards, third upwards and so on). Each column will only need to be highlighted up or down. New to excel don’t know if this is straight forward or not. Hope I’ve explained myself clearly, any assistance would be appreciated, really, been at it all day. Cheers -- JAZZNAURA ------------------------------------------------------------------------ JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961 View this thread: http://www.excelforum.com/showthread...hreadid=572852 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a macro
hi bob, sorry should have said, numerous rows and columns, A100 was just an example could be any cell, any row, any column. all with values of 2 to 50. -- JAZZNAURA ------------------------------------------------------------------------ JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961 View this thread: http://www.excelforum.com/showthread...hreadid=572852 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |