Drop Downs - Can a Response Trigger the Cell to Change Color?

Hello,

Is there a functionality whereby a cell changes color when someone chooses a drop-down choice? For example, my drop-down choices are:

Paid
Overdue
Sent

Is there a way to trigger the cell to change to Green if 'Paid' is chosen, Red if 'overdue' is chosen, and Blue if 'Sent' is chosen? I know there are rules I can create in a form submission, but this is just a raw creation of a sheet, manual input, no form being used/needed.

Thank you!

Find more posts tagged with

Accepted answers

Carson Penticuff

Here is the basic process to conditionally format the background of a cell based on its contents. In this scenario, you would need to setup three format options, one for each color/selection.

All comments

Carson Penticuff

Here is the basic process to conditionally format the background of a cell based on its contents. In this scenario, you would need to setup three format options, one for each color/selection.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.