Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Color code alternate rows based on date in google sheets

I would like to shade the rows based on alternate dates in google sheets. For example, the first row will always be unshaded, following that in the picture below, there is a new date "2021-03-19" in rows 2 and 3, hence they need to be shaded. Following that, next date, 2021-01-01 does not need to be and so on.

I have recently started using google sheets, not sure whether it can be achieved using any in built command.

Any suggestions would be appreciated.

enter image description here

like image 463
user3447653 Avatar asked Oct 24 '25 04:10

user3447653


1 Answers

try:

=ISEVEN(MATCH($A1, UNIQUE($A$1:$A), 0))

enter image description here

like image 124
player0 Avatar answered Oct 26 '25 22:10

player0