Numeric Values from one sheet to Highlight cells on another

Hi All,

I’m trying to assign building and office keys to various personnel, by appointing different classification levels to each set of keys given out. Very similar in the way an administrator would assign permission levels to individuals.

Question:
• Is there a way to pick up an array of non-sequential numbers from one sheet (values 1 -36)
• Find those values which are assigned to columns laid out as a table,
• Then highlight those found values

I’ve attached a dummy sheet to illustrate my question.

I have not attempted coding this because I wouldn’t know where to start.
Theoretically is this even possible?

Thanks

Mark

I think VBA is the way to go but I was just looking at this ... to limit the complexity of the conditional formats you'd have to setup you could use an adjacent matrix, eg:

Please Login or Register  to view this content.

You can then setup your 6 formats for 1-6 based on the values of these cells, eg with G4:AP38 highlighted:

Rule1:
=AT4=1
set format for permission 1

Rule2
=AT4=2
set format for permission 2

Rule3
=AT4=3
set format for permission 3

Rule 4
=AT4=4
set format for permission 4

Rule5
=AT4=5
set format for permission 5

Rule6
=AT4=6
set format for permission 6

Note: this is only possible with formula given use of XL2007 - earlier versions are limited to 3 conditional formats (plus standard) so in this instance would be a necessity.

StephenR , DonkeyOte,

Thanks for the suggestions.
Looks pretty interesting.
I'll give it a try and get back to you a little later.

Much appreciated.

Mark

StephenR,

Brilliant!
I used the VBA code and it works great.
Donkey Ote, I'll try your suggestion later when I get home.

Thanks again folks.

Mark