Friday, January 9, 2015

yogi-Conditionally Format First Instance of A Date In Range A2 to A

             Google Spreadsheet   Post  #1879
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-09-2015
post by  Noelle Devoe:
https://productforums.google.com/forum/#!mydiscussions/docs/RvNcqVCc1Ug
Highlight First Instance Of Date In Column Using Conditional Formatting?
I would like to highlight the first instance of a date in a column using conditional formatting, but I can for the life of me find the answer to this question.

Basically, in column A of my Google sheet, I have a list of dates and some repeat many times. I would like Sheets to highlight the first instance of every date. So it would be something like this (bold represents a highlighted cell):

1/1/2015
1/2/2015
1/2/2015
1/2/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/5/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015
1/6/2015

If anyone could help me figure this out, it would be greatly appreciated. And if it can't be done with conditional formatting, any direction as to how to achieve this would be much appreciated!

Thanks!
-------------------------------------------------------------------------------------------------------------------------------------------