We usually insert the lines with Date Beg and Date End in Sheet1.

For instance in 11_2 for column A2, I wrote 01.03.2016, but I can make a mistake when I enter a date beg and I can change the date from 01.03.2016 to 02.03.2016, so in Sheet 2, the begining time that system automatically colorized should change simultaneously when I change the date times in Sheet 1.

We want to see a visual colorized lines that you did in 11_2. But there isn't any formulas in Sheet 2 only we make it manual. We need a formula for Sheet 2.

Hopefully it undertood.