Hi
I have data set that changes regularly. When the data change what I want to have happen is to have the row colour like a table would base on the date in column K. i.e that is were the date is the same I and the row to be coloured. If only on colour an be used then colour the even or odd sets of dates with a colour
my example is below Rows 2 and 3 coloured
Row 4 to 7 no colour or lighter colour etc,etc where the same date is in Column "K"
Cheers
NZAS
<tbody>
</tbody>
I have data set that changes regularly. When the data change what I want to have happen is to have the row colour like a table would base on the date in column K. i.e that is were the date is the same I and the row to be coloured. If only on colour an be used then colour the even or odd sets of dates with a colour
my example is below Rows 2 and 3 coloured
Row 4 to 7 no colour or lighter colour etc,etc where the same date is in Column "K"
Cheers
NZAS
column "K" | ||||
First | Last | Certified | Expires | Days left |
Traci | Brown | 5/09/2016 | 5/09/2018 | 0 |
Mary | Hannan | 21/03/2016 | 5/09/2018 | 0 |
Linda | Thomas | 28/02/2016 | 28/02/2018 | 0 |
Sarah | Burton | 18/10/2016 | 28/02/2018 | 0 |
Kevin | Grizzle | 13/04/2016 | 28/02/2018 | 0 |
Chad | Jackson | 12/10/2016 | 28/02/2018 | 0 |
Alene | Helsel | 17/04/2016 | 12/10/2018 | 0 |
Jason | Ward | 16/03/2016 | 16/03/2018 | 0 |
Edward | Taylor | 22/12/2015 | 22/12/2017 | 0 |
Debbie | Jackson | 15/10/2016 | 22/12/2017 | 0 |
Lucy | Copeland | 1/05/2016 | 22/12/2017 | 0 |
Elaine | Evatt | 5/04/2016 | 22/12/2017 | 0 |
Robert | Williams | 3/11/2016 | 22/12/2017 | 0 |
Rita | Helms | 1/04/2016 | 22/12/2017 | 0 |
Richard | Hall | 9/06/2016 | 22/12/2017 | 0 |
Mark | Kroeger | 5/01/2016 | 5/01/2018 | 0 |
Carolyn | Perry | 12/03/2016 | 5/01/2018 | 0 |
<tbody>
</tbody>
Last edited: