Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2016, 05:31 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default Conditional Formating

I want to show the duration time with begining and ending time in Sheet2 with colorizing.
There is an example in Excel Sheet.
When I enter a date both begin and end time, my manager want to see the block time in month.
I colorized the Sheet 2 with hand made, but we want to system and formulas for this question.


Thanks for your aid.
Best regards.
Attached Files
File Type: xlsx 11.xlsx (13.1 KB, 12 views)
Reply With Quote
  #2  
Old 02-17-2016, 06:05 AM
xor xor is offline Conditional Formating Windows 10 Conditional Formating Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Conditional Formating

Is it something like this?
Attached Files
File Type: xlsx 11_2.xlsx (13.5 KB, 23 views)
Reply With Quote
  #3  
Old 02-17-2016, 06:56 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Is it something like this?
Yes, but for colurfuling the line, we want a formulation the duration time with beginning and ending time.
Reply With Quote
  #4  
Old 02-17-2016, 08:35 AM
xor xor is offline Conditional Formating Windows 10 Conditional Formating Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Sorry, but I am in doubt what you mean.
Reply With Quote
  #5  
Old 02-18-2016, 02:19 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
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
  #6  
Old 02-18-2016, 02:31 AM
xor xor is offline Conditional Formating Windows 10 Conditional Formating Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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?
Reply With Quote
  #7  
Old 02-18-2016, 02:46 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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.
Reply With Quote
  #8  
Old 02-18-2016, 03:07 AM
xor xor is offline Conditional Formating Windows 10 Conditional Formating Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Formulas are under Conditional Formatting (select for example Sheet2!A5 and press Conditional Formatting).

But I think I will stop here as I am still not sure I understand you (which may be due to the fact that English isn't my mother tongue).
Reply With Quote
  #9  
Old 02-18-2016, 05:01 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Formulas are under Conditional Formatting (select for example Sheet2!A5 and press Conditional Formatting).

But I think I will stop here as I am still not sure I understand you (which may be due to the fact that English isn't my mother tongue).
Where is formulas?

I didn't find...
Reply With Quote
  #10  
Old 02-18-2016, 05:02 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by Aseren View Post
Where is formulas?

I didn't find...
Ok, is there anybody to help me?
Reply With Quote
  #11  
Old 02-18-2016, 06:29 AM
gebobs gebobs is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Go to Home: Conditional Formatting: Manage Rules

Select the one rule that is there and click on Edit Rule.
Reply With Quote
  #12  
Old 02-18-2016, 06:43 AM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
Go to Home: Conditional Formatting: Manage Rules

Select the one rule that is there and click on Edit Rule.
Ok, but when ı copy the rule for full excel, it doesn4 work.
For full excel can we do the colorizing with your conditional formatting?
Reply With Quote
  #13  
Old 02-18-2016, 09:38 AM
gebobs gebobs is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Aseren View Post
Ok, but when ı copy the rule for full excel, it doesn4 work.
For full excel can we do the colorizing with your conditional formatting?
How are you copying the rule?

Go to Home: Conditional Formatting: Manage Rules

In the box for "Applies to", change the range to whatever you want. I made it for $A$3:$KT$100 and it seemed to work fine.

What are you trying to do here? A Gantt chart?
Reply With Quote
  #14  
Old 02-18-2016, 12:13 PM
Aseren Aseren is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Novice
Conditional Formating
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
How are you copying the rule?

Go to Home: Conditional Formatting: Manage Rules

In the box for "Applies to", change the range to whatever you want. I made it for $A$3:$KT$100 and it seemed to work fine.

What are you trying to do here? A Gantt chart?
Gantt chart is more difficult and we need more time for doing it. Because of this ı need a simple chart that we can work on it.

Thnks for your aid. It is exactly that ı need.

Best regards.
Reply With Quote
  #15  
Old 02-18-2016, 01:05 PM
gebobs gebobs is offline Conditional Formating Windows 7 64bit Conditional Formating Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Great, but don't thank me. Thank XOR. In fact, it would be nice if you would click the scales on the right of one of his posts and add to his reputation. Cheers!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating Copying Conditional Formating lynette Excel 2 03-06-2015 11:53 AM
Conditional Formating MaineLady Excel 1 11-05-2014 06:37 PM
Chart Formating with ChartTitle Font and DataLabel Formating shilabrow Excel Programming 0 06-30-2014 10:01 AM
Conditional Formating more Conditional Formating princeofsadness Excel 2 09-05-2011 02:14 AM
After formating PC milkmile Outlook 2 10-12-2010 06:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft