muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,089
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i have date layout table, how to check using Conditional Formatting. to find / detect consecutive date (eg. month).
[TABLE="width: 205"]
<tbody>[TR]
[TD]date[/TD]
[TD]after using CF[/TD]
[/TR]
[TR]
[TD="align: right"]30/01/2017[/TD]
[TD="align: right"]30/01/2017[/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2017[/TD]
[TD="align: right"]02/02/2017[/TD]
[/TR]
[TR]
[TD="align: right"]20/03/2017[/TD]
[TD="align: right"]20/03/2017[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/2017[/TD]
[TD="align: right"]16/05/2017[/TD]
[/TR]
[TR]
[TD="align: right"]11/06/2017[/TD]
[TD="align: right"]11/06/2017[/TD]
[/TR]
[TR]
[TD="align: right"]23/07/2017[/TD]
[TD="align: right"]23/07/2017[/TD]
[/TR]
[TR]
[TD="align: right"]12/08/2017[/TD]
[TD="align: right"]12/08/2017[/TD]
[/TR]
[TR]
[TD="align: right"]13/10/2017[/TD]
[TD="align: right"]13/10/2017[/TD]
[/TR]
</tbody>[/TABLE]
any help..much appreciated...
m.susanto
i have date layout table, how to check using Conditional Formatting. to find / detect consecutive date (eg. month).
[TABLE="width: 205"]
<tbody>[TR]
[TD]date[/TD]
[TD]after using CF[/TD]
[/TR]
[TR]
[TD="align: right"]30/01/2017[/TD]
[TD="align: right"]30/01/2017[/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2017[/TD]
[TD="align: right"]02/02/2017[/TD]
[/TR]
[TR]
[TD="align: right"]20/03/2017[/TD]
[TD="align: right"]20/03/2017[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/2017[/TD]
[TD="align: right"]16/05/2017[/TD]
[/TR]
[TR]
[TD="align: right"]11/06/2017[/TD]
[TD="align: right"]11/06/2017[/TD]
[/TR]
[TR]
[TD="align: right"]23/07/2017[/TD]
[TD="align: right"]23/07/2017[/TD]
[/TR]
[TR]
[TD="align: right"]12/08/2017[/TD]
[TD="align: right"]12/08/2017[/TD]
[/TR]
[TR]
[TD="align: right"]13/10/2017[/TD]
[TD="align: right"]13/10/2017[/TD]
[/TR]
</tbody>[/TABLE]
any help..much appreciated...
m.susanto
Last edited: