Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |