Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
i want to change background color for date fields when date is not in sequence ,
for example when date sequence like
05-04-2017
05-04-2017
05-04-2017
06-04-2017
05-04-2017
05-04-2017
in this i want to change background color of date when sequence is change,i,e different date is coming in between date.
for clear under standing i attached sample data.desired out put also is same sample data file.
Hi manish,
For a4202 body it is by mistake background colour is wrong.sorry for this because it is sample data.
Sorry for inconvenience.
Hi
Can this help you.
PFA
Can you update the excel and reattached it here?
hi manish,
here i paste the data and mark as bold for background colour.
id | body | acc | acc_date | body_date | final_date |
a146 | btc1705 | 145792 | 05-04-2017 | 05-04-2017 | 05-04-2017 |
a458 | btc1706 | 148794 | 05-04-2017 | 05-04-2017 | 06-04-2017 |
a770 | btc1707 | 148795 | 06-04-2017 | 05-04-2017 | 05-04-2017 |
a1082 | btc1708 | 150796.7 | 05-04-2017 | 05-04-2017 | 05-04-2017 |
a1394 | btc1709 | 152298.2 | 05-04-2017 | 05-04-2017 | 05-04-2017 |
a1706 | btc1710 | 153799.7 | 05-04-2017 | 05-04-2017 | 05-04-2017 |
a2018 | btc1711 | 155301.2 | 07-04-2017 | 07-04-2017 | 07-04-2017 |
a2330 | btc1712 | 156802.7 | 07-04-2017 | 09-04-2017 | 07-04-2017 |
a2642 | btc1713 | 158304.2 | 07-04-2017 | 07-04-2017 | 07-04-2017 |
a2954 | btc1714 | 159805.7 | 08-04-2017 | 07-04-2017 | 07-04-2017 |
a3266 | btc1715 | 161307.2 | 07-04-2017 | 07-04-2017 | 07-04-2017 |
a3578 | btc1716 | 162808.7 | 04-04-2017 | 04-04-2017 | 04-04-2017 |
a3890 | btc1717 | 164310.2 | 04-04-2017 | 04-04-2017 | 05-04-2017 |
a4202 | btc1718 | 165811.7 | 04-04-2017 | 05-04-2017 | 04-04-2017 |
a4514 | btc1719 | 167313.2 | 04-04-2017 | 04-04-2017 | 04-04-2017 |
a4826 | btc1720 | 168814.7 | 04-04-2017 | 04-04-2017 | 04-04-2017 |
a5138 | btc1721 | 170316.2 | 06-07-2017 | 04-04-2017 | 04-07-2017 |
a5450 | btc1722 | 171817.7 | 04-04-2017 | 04-04-2017 | 04-04-2017 |
a5762 | btc1723 | 173319.2 | 04-04-2017 | 04-04-2017 | 04-04-2017 |
looks like some of the entry in date is wrong.