CODEWITHSUNDEEP
google-sheetsmatchgoogle-sheets-formulauniqueconditional-formatting
user3447653
user3447653

Reputation: 4158

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

Upvotes: 4

Views: 2252

Answers (1)

player0
player0

Reputation: 1

try:

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

enter image description here

Upvotes: 6

Related Questions