Quote:
Originally Posted by xor
That's exactly what I did in 11_2. How you actually tried to change Date Beg and Date End in Sheet1 (rows 2:4) and noticed what happens in Sheet2?
|
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.