formula - I have a field that has drop down choices of several items and I would like the discontinued items to show up in "red". I need help writing a formula for that. Example: So it item "abc" is checked discontinued then it will show in red
You cannot control the color of the drop down choices. However, if you have a relationships to control that drop down, then you can specify any report to use for the drop down, and so you can make a report called drop down choices of active Items with just Active items, so that the discontinued items will not be offered as choice.
Sorry I think maybe I am wording my question incorrectly. I have a table of just item codes and some are discontinued items. How can I write a formula showing the disco items in red? They are in a table and have a check box that once checked it keeps the reps from seeing those items and I would like them to still show in red since Admin can still see them.