i am looking for way to highlight only sunday of current week. every time i open the excel it should only highlight that way.
can someone help with the same. thanks. data looks like below-
<colgroup><col><col></colgroup><tbody>
</tbody>
can someone help with the same. thanks. data looks like below-
week | date |
1 | 2/11/2018 |
2 | 2/18/2018 |
3 | 2/25/2018 |
4 | 3/4/2018 |
5 | 3/11/2018 |
6 | 3/18/2018 |
7 | 3/25/2018 |
8 | 4/1/2018 |
9 | 4/8/2018 |
10 | 4/15/2018 |
11 | 4/22/2018 |
12 | 4/29/2018 |
13 | 5/6/2018 |
14 | 5/13/2018 |
15 | 5/20/2018 |
16 | 5/27/2018 |
17 | 6/3/2018 |
18 | 6/10/2018 |
19 | 6/17/2018 |
20 | 6/24/2018 |
21 | 7/1/2018 |
22 | 7/8/2018 |
23 | 7/15/2018 |
24 | 7/22/2018 |
25 | 7/29/2018 |
26 | 8/5/2018 |
27 | 8/12/2018 |
28 | 8/19/2018 |
29 | 8/26/2018 |
30 | 9/2/2018 |
31 | 9/9/2018 |
32 | 9/16/2018 |
33 | 9/23/2018 |
34 | 9/30/2018 |
35 | 10/7/2018 |
36 | 10/14/2018 |
37 | 10/21/2018 |
38 | 10/28/2018 |
39 | 11/4/2018 |
40 | 11/11/2018 |
41 | 11/18/2018 |
<colgroup><col><col></colgroup><tbody>
</tbody>