How would you do this without referencing values in your pulldown? I'd like rows and columns to highlight based solely on which arbitrary cell I have selected.
Hi @quartzimaging, I have been unable to find a Conditional Formatting solution for that, but some people have been able to do that with Apps Script. Here are two Apple Scrip formulas: 1. spreadsheetlearning.com/highlight-active-cell-row-column-in-google-sheets/ 2. tanaikech.github.io/2020/06/11/highlighting-row-and-column-of-selected-cell-using-google-apps-script/ Cheers!
Use this formula: A1 should be the start of your range. Here's what each part of the formula does: Checks if the content of cell A1 is text. This ensures that we are working with text values and not numbers or other data types. Compares the content of cell A1 with its uppercase version. The EXACT function returns TRUE only if both arguments are exactly the same. This part ensures that all characters in the cell are already in uppercase. Checks if the length of the text in cell A1 is greater than 0. This ensures that we are not formatting empty cells.
❤
thanks. it was the answer of my question :)
How would you do this without referencing values in your pulldown? I'd like rows and columns to highlight based solely on which arbitrary cell I have selected.
Hi @quartzimaging,
I have been unable to find a Conditional Formatting solution for that, but some people have been able to do that with Apps Script.
Here are two Apple Scrip formulas:
1. spreadsheetlearning.com/highlight-active-cell-row-column-in-google-sheets/
2. tanaikech.github.io/2020/06/11/highlighting-row-and-column-of-selected-cell-using-google-apps-script/
Cheers!
Thank you!
@@akistepinska
@@akistepinska It seems it's not working. Whenever I open the extension>AppScript, I can't load the browser. It ended up with error.
Thank you.
How to Highlight the rows which contain capital letters only
Use this formula:
A1 should be the start of your range.
Here's what each part of the formula does:
Checks if the content of cell A1 is text. This ensures that we are working with text values and not numbers or other data types.
Compares the content of cell A1 with its uppercase version. The EXACT function returns TRUE only if both arguments are exactly the same. This part ensures that all characters in the cell are already in uppercase.
Checks if the length of the text in cell A1 is greater than 0. This ensures that we are not formatting empty cells.