Thread: [Solved] Conditional Formating
View Single Post
 
Old 02-18-2016, 02:19 AM
Aseren Aseren is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Sorry, but I am in doubt what you mean.
Ok, I will explain.
For instance; When I enter the date time in Sheet 1 both beginning and ending, I want to show the duration period time in Sheet 2.

Duration time: Ending time-Beginning time.

In Sheet2, I colorized the lines with manual. But we want to see colurized line automatically with beginning and ending time when ı enter the date times in Sheet 1.
Attached Files
File Type: xlsx 11.xlsx (18.8 KB, 10 views)
Reply With Quote