conditional formattinggoogle sheets
I have cells containing some text:
I want to automatically make all the occurrences of cell to be bold:
Is this possible ?
You don't need a script for that; the built-in conditional formatting tools are flexible enough. Assuming the first row is for headers, apply conditional formatting to the range A2:A, with custom formula =len(join("", B2:Z2)). This means: join the content of cells, and find its length; the formatting applies if the length is greater than 0.
Replace Z by AZ or something else if you have more columns. (The formula will automatically adjust if you insert more columns between A and Z later.)
Bold formatting is found in the formatting dropdown, select "Custom" as below.
If your tags occur in Col B (starting at row 2), paste the below formula in column C (row 2) to get all unique tags in the Col B
=unique(transpose(split(CONCATENATE(arrayformula(B2:B&",")),",")))
To get the number of occurrence of certain tag in col B, paste the below in col D row 2
=ARRAYFORMULA(if(countif(transpose(split(CONCATENATE((B2:B&",")),",")),C2:C) = 0, "",countif(transpose(split(CONCATENATE((B2:B&",")),",")),C2:C)))
All the formulas used are standard formulas in Google Sheets.
Best Answer
At this time it's not possible to automatically format certain words in cell values.
There is a feature request on the Google Apps Script Issue Tracker. Please star it to tell Google that we want this feature.