Conditional Formatting Offset

In the attached file I would like to highlight all Stores in the selected (via the UserForm) Manager's Region. I can't seem to figure out how to highlight one column to the right of the value returned by VLookup.

Thank you.

Hi, tommy_m,

if you compare the Value of say B3 to South you will find no match. So you need to change the Conditional Formatting from Cell Value to Expression:

Please Login or Register  to view this content.

You might even think about using different colour codes for the managers, i.e.

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Tommy,

...but does not highlight anything in Excel 2003

If you change a code that works please take care that you copy all relevant parts (you missed the assignment of the cells as being absolute in column, and I usually work with multiple areas a little bit different):

Your code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Tested in Excel 2000 - but I would break down the single areas as otherwise only the value in Column A is taken for to colour the cells but not the value in the column next to the colour. This would mean work with a loop for the three areas instead of marking one great area. Can you do that on your own?

Ciao,
Holger