Change Picture Based On DropDown ComboBox Selection Cell Validation Using Formula

[Excel Fox]

Well in that case, you have to do exactly what Admin suggested.

For each additional card you need, you'll have to create named ranges. Example

rngCurrentName01
rngNameIndex01
rngPictureIndex01

for the first card,


rngCurrentName02
rngNameIndex02
rngPictureIndex02

for the second card, so on and so forth.

There's also a conditional formatting that is done using formula for all the cells below the names of each person. Just select all the 18 cells (including the cells underneath the picture), and go to conditional format. You'll find the criteria. All of them are almost identical, except the criteria for each color

So, instead of =SUMPRODUCT(LOOKUP(OFFSET(INDIRECT("rng"&F4),rngNa meIndex,0),Vect,Rslt))>=13, you'll need to use

=SUMPRODUCT(LOOKUP(OFFSET(INDIRECT("rng"&F4),rngNa meIndex01,0),Vect,Rslt))>=13
OR
=SUMPRODUCT(LOOKUP(OFFSET(INDIRECT("rng"&F4),rngNa meIndex02,0),Vect,Rslt))>=13, so on and so forth

Find attached a sample