Is there a way to apply conditional formatting to specific values within a cell of comma-separated values?
Background
In a Google form, I have a Checkboxes-type question with 50 options that increment by 1, from
CACHE 1
toCACHE 50
.
Checkbox Question ( Form )
In Google Sheets, each form response combines the 5selectedselected options in a single column as comma-separated values.
Form Responses ( Spreadsheet )
A B 1 Timestamp Check all that apply: 2 9/6/2024 15:59:41 CACHE 1, CACHE 3, CACHE 17, CACHE 29 3 9/6/2024 15:59:45 CACHE 3, CACHE 29 4 9/6/2024 15:59:49 CACHE 1, CACHE 17, CACHE 49, CACHE 50 5 9/6/2024 16:01:10 CACHE 29, CACHE 49 I want to apply conditional formatting to individual options within the comma-separated values but can't figure out how.
Desired Result ( Spreadsheet )