Color of text/Data in a Cell
 

I have two column totals that are formatted in Time:
=SUMIF(D2:D30,"Him",C2:C30) and =SUMIF(D2:D30,"Me",C2:C30) I want to subtract
"Him" Totals from "Me" totals and show the results as either a positve time
in Black or a Negitive Time in Red? The Formula I have now for that cell is
as follows: =TEXT(ABS(E31-F31),"h:mm")

Color of text/Data in a Cell
 

You have two options

1. Use conditional formatting and select "formula is" and use the following
formula

=$E$31<$F$31

click "format" and go to the "font" tab and change the font color to red.



2. If you change the dating system ot the 1904 Date System
(tools-options-calculation) you will be able to handle negative times. You
can then use the formula

=E31-F31

and use the custom format of

h:mm;[Red]h:mm

"Fast Learner" wrote:

I have two column totals that are formatted in Time:
=SUMIF(D2:D30,"Him",C2:C30) and =SUMIF(D2:D30,"Me",C2:C30) I want to subtract
"Him" Totals from "Me" totals and show the results as either a positve time
in Black or a Negitive Time in Red? The Formula I have now for that cell is
as follows: =TEXT(ABS(E31-F31),"h:mm")

Color of text/Data in a Cell
 

Sloth'
Thanks alot I used the change the dating system to the 1904 Date System and
it worked fine.

"Sloth" wrote:

You have two options

1. Use conditional formatting and select "formula is" and use the following
formula

=$E$31<$F$31

click "format" and go to the "font" tab and change the font color to red.



2. If you change the dating system ot the 1904 Date System
(tools-options-calculation) you will be able to handle negative times. You
can then use the formula

=E31-F31

and use the custom format of

h:mm;[Red]h:mm

"Fast Learner" wrote:

I have two column totals that are formatted in Time:
=SUMIF(D2:D30,"Him",C2:C30) and =SUMIF(D2:D30,"Me",C2:C30) I want to subtract
"Him" Totals from "Me" totals and show the results as either a positve time
in Black or a Negitive Time in Red? The Formula I have now for that cell is
as follows: =TEXT(ABS(E31-F31),"h:mm")