I want to be able to update a field to have a text value + colour based on the selection from 2 fields (that contain dropdown lists - I can set a rule to update colour but can't work out how to also populate it with texts
So, Field C13 contains 3 values - e.g. A, B, C
Field C14 contains 3 values - e.g. XYZ
Field E14 should update to
Yes and Green if values A and X are selected
Maybe and Amber if values B and Y are selected
No and Red if values C and Z are selected
9 combinations in total
Anyone can help?
Bookmarks