| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula help please
Ron Rosenfeld wrote:
On Wed, 29 Jun 2011 10:55:06 -0700, "Jim Cone" wrote: You do that with a custom number format... [Green]General;[Red]General;General That should be: [Green]General;[Red]General; (Omit the last General, but NOT the last semi-colon, in order to have zero be blank). To elaborate for Jennifer, your cell containing the formula should contain: =C1-C2 Then Right Click on that cell and select Format/Number/Custom Type: and enter: [Green]General;[Red]General; Thank you guys. I appreciate it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![Jennifer[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
