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?
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!
-------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment