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

Options
Stef Seaker
Stef Seaker ✭✭
edited 07/13/23 in API & Developers

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!

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    edited 07/13/23 Answer ✓
    Options

    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.


Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    edited 07/13/23 Answer ✓
    Options

    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.