CareerChange
03-26-2011, 10:49 AM
I have a five item Data Validation List, and the cells that contain those five entries have specific interior and font colors that represent well known trademarked logos.
The List works perfectly, however the in-cell dropdown did not hold the specific color formats. I figured that even if the dropdown didn't look the way I wanted it to, I decided to use the Conditional Format builder to set those specific color values upon selection. Well, the builder only allows for three conditions, so two of my choices do not have their color conditions applied upon selection.
What are my options to either solve the visual contents of the dropdown, and/or apply more than three conditional formats?
Thanks!
The List works perfectly, however the in-cell dropdown did not hold the specific color formats. I figured that even if the dropdown didn't look the way I wanted it to, I decided to use the Conditional Format builder to set those specific color values upon selection. Well, the builder only allows for three conditions, so two of my choices do not have their color conditions applied upon selection.
What are my options to either solve the visual contents of the dropdown, and/or apply more than three conditional formats?
Thanks!