Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Can I auto change text to RED if a user overwrites a formula? | Excel Discussion (Misc queries) | |||
Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
Change number to text formula | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |