Excel 2010 Icon Set relative to drop down menu in seperate column - TechRepublic
Question
June 17, 2013 at 12:51 PM
dlmhc8

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

by dlmhc8 . Updated 13 years ago

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!

This discussion is locked

All Comments