Match a cell against a named range

**bignowa** · 11-02-2011, 05:29 PM

I am struggling with most probably a straight forward problem, but here goes. I want to write some VB coding to match cell values to a list I have already made "Stock" so that only rows with the values that don't match get highlighted in red. My problem is being able to reference the list "Stock" in VB - is it possible?

Sheet 1 contains my named ranges, and sheet 2 is where data gets entered. So basically is there any way to say if Activecell is found in named range then color no fill, if not color red.

Thanks in advance. I'm sure it's not as simple as I'm trying to make it. Eventually it might build to names and not just numbers that I'm looking up as well.

Please Login or Register  to view this content.

**tigeravatar** · 11-02-2011, 06:14 PM

bignowa,

Why not use conditional formatting? See attached

**rylo** · 11-02-2011, 06:16 PM

Hi

Not sure why conditional formatting wouldn't be a better option.

Put up an example workbook for review.

rylo

**bignowa** · 11-02-2011, 06:26 PM

I was just thinking about conditional formatting but I wasn't quite sure how to set up the formula, but I think this will definitely do the trick. Thanks for your help!