Question Locked

Excel 2010 Icon Set relative to drop down menu in seperate column

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I would like to assign icon sets to values which are dependent on 1 of 5 drop down menu options in a seperate column.
So, literally I would like the icon sets to do the following:
If the value in G2 = “APC” and cell value in H2 >10,000 red, = 8,000-10,000 yellow, < 8000 green
If the value in G2 = “Generic E. Coli” and cell value in H2 > 500 red, =100-500 yellow, < 100 green
If the value in G2 = “Coliform” and cell value in H2 > 1000 red, = 500-1000 yellow, < 500 green
If the value in G2 = “Listeria” and cell value in H2 > 0 red

Is this possible?
Thanks!

1 reply

This discussion is closed to new replies.