This would require programming in VBA.

Doable, but not with a standard Excel formula.

"JAZZNAURA" wrote:


Hi all,

Need some help! 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 (also in some cases the cells above instead of
below). Can this be done with out the use of a macro? A column will
only need to be highlighted up or down. So looking for 2 formulas one
to highlight down and one to highlight up, which I can paste in every
other column.

New to excel dont know if this is straight forward or not.

Hope Ive explained myself clearly, any assistance would be
appreciated.

Cheers


--
JAZZNAURA
------------------------------------------------------------------------
JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961
View this thread: http://www.excelforum.com/showthread...hreadid=572793