I have a spreadsheet that is in Google Sheets which has a column that I want to format conditionally. I want to format it, such that groups of rows which all hold the same value are dark grey, while they next group of rows of all the same value are light grey. For example, I want the sheet to look something like this:
The numbers will not neccesarily be grouped in order, so I can't just use
=mod(a1,2)=1 for the conditional format. I also would like it to update so that no matter how the other columns are filtered, this column remains such that every time the value in the next row is different, it and its duplicates are all a new color, mainly for visualization, to see which data is grouped together.
If I'm to use the formulae
=isodd(countunique(a$2:a2)) and then apply some filter, then I get the following, which doesn't alternate the colors based on what is shown.
Any help would be great. Thanks.
for the light grey and
for the dark grey
The same question was asked in Excel recently and I realised it would be more straightforward just to count the changes of value like this:
It doesn't solve the filtering question though.
- Create a new sheet in a Google Sheets with Google Apps Script
- gspread update_cells writes to wrong place
- In AppScript, when multiple ranges are edited at once, How is rangeList obtained?
- Access local nodejs server from google spreadsheets
- Google Sheets cant make a formula that identifies cells having a 0 in it
- Compare two columns for matches and pull the adjacent value for each match
- Google Sheets OnEdit() - You do not have permission to call showModalDialog
- Google sheet formula to swap names
- Why doesn't the trigger work for the script running a function on my google spreadsheet?
- LOOKUP with dropdown list doesn't work for some keys