help with a macro

[JAZZNAURA]

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

 

[Bob Phillips]

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]

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.

 

[Bob Phillips]

Then you need to replace 100 with whatever you use to determine the row.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)