Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 06, 11:40 PM posted to microsoft.public.excel.misc
bailfire13
 
Posts: n/a
Default 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?

  #2   Report Post  
Old May 30th 06, 11:46 PM posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How do I change formula results by changing the text color of the

Pull-down:

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   Report Post  
Old May 30th 06, 11:46 PM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default How do I change formula results by changing the text color of the

If you switch to the 19043 date system , ToolsOptionsCalculation, 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   Report Post  
Old May 30th 06, 11:51 PM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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 , ToolsOptionsCalculation, 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   Report Post  
Old May 31st 06, 04:41 PM posted to microsoft.public.excel.misc
bailfire13
 
Posts: n/a
Default 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:

Pull-down:

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 07: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 02:57 AM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017