Skip to main content
add markdown data
Source Link
Blindspots
  • 7.5k
  • 5
  • 20
  • 38

Is there a way to apply conditional formatting to specific values within a cell of comma-separated values?

  Background

  1. In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from CACHE 1 to CACHE 50 .
    Checkbox Question ( Form )
    Checkbox question
     

  2. In Google Sheets, each form response combines the 5selectedselected options in a single column as comma-separated values.
    Form Responses ( Spreadsheet )
    Form responses
      

    AB
    1TimestampCheck all that apply:
    29/6/2024 15:59:41CACHE 1, CACHE 3, CACHE 17, CACHE 29
    39/6/2024 15:59:45CACHE 3, CACHE 29
    49/6/2024 15:59:49CACHE 1, CACHE 17, CACHE 49, CACHE 50
    59/6/2024 16:01:10CACHE 29, CACHE 49
  3. I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
    Desired Result ( Spreadsheet )
    Desired Result

Is there a way to apply conditional formatting to specific values within a cell of comma-separated values?

  Background

  1. In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from CACHE 1 to CACHE 50 .
    Checkbox Question ( Form )
    Checkbox question
     

  2. In Google Sheets, each form response combines the 5selected options in a single column as comma-separated values.
    Form Responses ( Spreadsheet )
    Form responses
      

  3. I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
    Desired Result ( Spreadsheet )
    Desired Result

Is there a way to apply conditional formatting to specific values within a cell of comma-separated values?

  Background

  1. In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from CACHE 1 to CACHE 50 .
    Checkbox Question ( Form )
    Checkbox question
     

  2. In Google Sheets, each form response combines the selected options in a single column as comma-separated values.
    Form Responses ( Spreadsheet )
    Form responses

    AB
    1TimestampCheck all that apply:
    29/6/2024 15:59:41CACHE 1, CACHE 3, CACHE 17, CACHE 29
    39/6/2024 15:59:45CACHE 3, CACHE 29
    49/6/2024 15:59:49CACHE 1, CACHE 17, CACHE 49, CACHE 50
    59/6/2024 16:01:10CACHE 29, CACHE 49
  3. I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
    Desired Result ( Spreadsheet )
    Desired Result

edit for clarity and terminology
Source Link
Blindspots
  • 7.5k
  • 5
  • 20
  • 38

Google Sheets/Forms conditional formatting with Conditionally format specific values within comma separates' looking for multiple selections-separated values

I am haveIs there a form where multiple items can be selected (CACHE radios) I haveway to apply conditional formatting to specific values within a sheet that has each CACHE radio (CACHE 1cell of comma-CACHE 50). When the form is filled out it shows the radio(s) checked out. The issue is I cannot make the individual radios turn red if there are multiple because it is seperated by commas. Cache 1, Cache 2, Cache 3,separated values?

  Background

  1. In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from CACHE 1 to CACHE 50 .
    Checkbox Question ( Form )
    Checkbox question
     

  2. In Google Sheets, each form response combines the 5selected options in a single column as comma-separated values.
    Form Responses ( Spreadsheet )
    Form responses
     

  3. I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
    Desired Result ( Spreadsheet )
    Desired Result

Google Sheets/Forms conditional formatting with comma separates' looking for multiple selections

I am have a form where multiple items can be selected (CACHE radios) I have a sheet that has each CACHE radio (CACHE 1-CACHE 50). When the form is filled out it shows the radio(s) checked out. The issue is I cannot make the individual radios turn red if there are multiple because it is seperated by commas. Cache 1, Cache 2, Cache 3,

Conditionally format specific values within comma-separated values

Is there a way to apply conditional formatting to specific values within a cell of comma-separated values?

  Background

  1. In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from CACHE 1 to CACHE 50 .
    Checkbox Question ( Form )
    Checkbox question
     

  2. In Google Sheets, each form response combines the 5selected options in a single column as comma-separated values.
    Form Responses ( Spreadsheet )
    Form responses
     

  3. I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
    Desired Result ( Spreadsheet )
    Desired Result

Source Link
Jimmy
  • 11
  • 1

Google Sheets/Forms conditional formatting with comma separates' looking for multiple selections

I am have a form where multiple items can be selected (CACHE radios) I have a sheet that has each CACHE radio (CACHE 1-CACHE 50). When the form is filled out it shows the radio(s) checked out. The issue is I cannot make the individual radios turn red if there are multiple because it is seperated by commas. Cache 1, Cache 2, Cache 3,