Search code examples
google-sheetsmatchgoogle-sheets-formulauniqueconditional-formatting

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


Solution

  • try:

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

    enter image description here