Forum Discussion
Conditional Picture Insert
I am trying to find a way to automate a procedure for a client review at work.
I would have a cell that contains the clients attitude to investment risk - e.g. "Cautious", "Balanced" or "Adventurous".
Depending which of the 3 options is selected, I would like a cell next to it to pre-populate with a picture/icon that contains the numbers "3", "4" or "5". In this case - Cautious = 4, Balanced = 5 and Adventurous = 6.
Would anyone be able to advise please?
Depending which of the 3 options is selected, I would like a cell next to it to pre-populate with a picture/icon that contains the numbers "3", "4" or "5". In this case - Cautious = 4, Balanced = 5 and Adventurous = 6.
You do realize, I trust, that the numbers you suggested in your last two sentences are inconsistent; in one case ranging from 3 to 5, in the other from 4 to 6.
Anyway, see the attached. I can't believe that you aren't also expecting a much more complete spreadsheet that will show different scenarios based on this first selection. This particular detail has got to be fairly minor. Is all the rest in place?
