Question

Locked

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

By dlmhc8 ·
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 conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums