Hello,
I have developed a dropdown list composed of the following elements:
Planned Compliant
Verified Compliant
Not Compliant
Planned Compliant per Waiver (see note)
Verified Compliant per Waiver
Then by using data validation i assigned to each the following colors:
Planned Compliant ----- yellow
Verified Compliant ----- green
Not Compliant ------ red
Planned Compliant per Waiver (see note) ----orange
Verified Compliant per Waiver ------blue
Ok so everything works a part the fact that when i choose:
Verified Compliant ---- the colour is green
Verified Compliant per Waiver ---- the colour is green instead of blue
Whant should i do? Apparently the system is confusing ''Verified Compliant per Waiver '' with ''Verified Compliant'' since they are very similar.
Thank you
Bookmarks