Thanks for the reply.

The formula would not give me the flexibility if the value returned was
higher or lower, would it RagDyer? Sorry if I didn’t make myself clear,
may need to highlight 6 cells of 60, depending on the value return by
vlook up formula.

Dave F, when you say vba programming, do you mean a macro? If so reason
for not using is to keep file size to minimum, hope I’m correct in my
thinking here.

Apologies if I’ve made incorrect statements here.

RayDyer, Is the formula flexible in that sense?

Dave F r u talking about a macro and would it be simple to do?

cheers again


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