If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How do I change formula results by changing the text color of the
I'm working with times (0:00:42) on Excel 2003, and cannot make a time go
negative (0:00:42  0:01:00). I figured out how to change the text color of the number if the number should be negative. I now want to know how to create a formula that is dependant on the text color of the numbers. I would like to add the black numbers and subtract the red numbers. Is there anyone that knows how to do this? Or better yet, is there a way to make a time go negative? 
Ads 
#2




How do I change formula results by changing the text color of the
Pulldown:
Tools > Options > Calculate and check 1904 date system near the bottom  Gary's Student "bailfire13" wrote: > I'm working with times (0:00:42) on Excel 2003, and cannot make a time go > negative (0:00:42  0:01:00). I figured out how to change the text color of > the number if the number should be negative. I now want to know how to > create a formula that is dependant on the text color of the numbers. I would > like to add the black numbers and subtract the red numbers. Is there anyone > that knows how to do this? Or better yet, is there a way to make a time go > negative? 
#3




How do I change formula results by changing the text color of the
If you switch to the 19043 date system , Tools>Options>Calculation, 1904
date system checkbox, you can get negative dates.  HTH Bob Phillips (remove nothere from the email address if mailing direct) "bailfire13" > wrote in message ... > I'm working with times (0:00:42) on Excel 2003, and cannot make a time go > negative (0:00:42  0:01:00). I figured out how to change the text color of > the number if the number should be negative. I now want to know how to > create a formula that is dependant on the text color of the numbers. I would > like to add the black numbers and subtract the red numbers. Is there anyone > that knows how to do this? Or better yet, is there a way to make a time go > negative? 
#4




How do I change formula results by changing the text color of the
That's 1904, not 19043. Even Excel hasn't got there yet <g>
 HTH Bob Phillips (remove nothere from the email address if mailing direct) "Bob Phillips" > wrote in message ... > If you switch to the 19043 date system , Tools>Options>Calculation, 1904 > date system checkbox, you can get negative dates. > >  > > HTH > > Bob Phillips > > (remove nothere from the email address if mailing direct) > > "bailfire13" > wrote in message > ... > > I'm working with times (0:00:42) on Excel 2003, and cannot make a time go > > negative (0:00:42  0:01:00). I figured out how to change the text color > of > > the number if the number should be negative. I now want to know how to > > create a formula that is dependant on the text color of the numbers. I > would > > like to add the black numbers and subtract the red numbers. Is there > anyone > > that knows how to do this? Or better yet, is there a way to make a time > go > > negative? > > 
#5




How do I change formula results by changing the text color of
Wow, thanks for the answer, Gary's Student and Bob. This makes my job a lot
easier! "Gary''s Student" wrote: > Pulldown: > > Tools > Options > Calculate and check 1904 date system near the bottom >  > Gary's Student > > > "bailfire13" wrote: > > > I'm working with times (0:00:42) on Excel 2003, and cannot make a time go > > negative (0:00:42  0:01:00). I figured out how to change the text color of > > the number if the number should be negative. I now want to know how to > > create a formula that is dependant on the text color of the numbers. I would > > like to add the black numbers and subtract the red numbers. Is there anyone > > that knows how to do this? Or better yet, is there a way to make a time go > > negative? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
abdualmohsn  almedrahe abdualmohsn ahmad  Excel Discussion (Misc queries)  1  November 19th 05 06:32 PM 
Can I auto change text to RED if a user overwrites a formula?  rrucksdashel  Excel Discussion (Misc queries)  2  September 12th 05 10:10 PM 
Change formula for Employee Shift Schedule template  Pam Soreide  Excel Worksheet Functions  1  September 7th 05 03:10 AM 
Change number to text formula  Fesk  Excel Worksheet Functions  1  August 30th 05 01:11 AM 
Cannot change a formula  Richard F  Excel Discussion (Misc queries)  1  January 18th 05 01:57 AM 