Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Conditional Format - Drop down list?

Featured Replies

Hi,

Is it possible to add conditional formatting to a drop down list?

I was hoping to add a second field to my list that would show 'In Stock',then if the value contained 'In Stock' it would highlight in red.

This would allow me to quickly identify the items in the list that are in stock. I have the second field with this info, but a colour change would be even better.

Thanks in advance,

Skip

  • Author

Thanks. it would be nice... let me find the suggestion box!

Now that I have some more time, let me share the thoughts I had reading your post.

1. You are using a drop-down list. Hmmm. I wonder, for what? Is it to help a user select a product in a line items table? If so, a drop down list is not the best choice, because you want to store an ID, not a product text description, in the line items table. Apparently, you have two fields that comprise the value list, so you do not seem to be using an ID at all. Not good.

2. Drop-downs and popup menus sometimes become unwieldy when the number of selections exceed 10. That's the time to explore other interface techniques for selections. One technique is a popup select window. With such an interface, you could easily filter the selection choices to "in stock" or all.

3. I wonder how you determine if an item is "in stock."

Perhaps, if you want, you could share with us your data model.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.