Maybe you don't need macro at all.
Try
Format-- Condition Formating...

"JAZZNAURA" wrote:


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 dont know if this is straight forward or not.

Hope Ive 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=572854