Feb 22, 2005 #1 mystuff Programmer Apr 30, 2004 86 US Hi, Can anyone tell me how I would print a negative value in red and positive values will remain in black? Thanks
Hi, Can anyone tell me how I would print a negative value in red and positive values will remain in black? Thanks
Feb 22, 2005 #2 RoyVidar Instructor Jun 16, 2000 6,606 NO You could try using conditional formatting on the control (2000+ versions), or in the format property of the control: [tt]0.00;[Red]0.00[/tt] press F1 while in the format proerty to see more about how to build those formats Roy-Vidar Upvote 0 Downvote
You could try using conditional formatting on the control (2000+ versions), or in the format property of the control: [tt]0.00;[Red]0.00[/tt] press F1 while in the format proerty to see more about how to build those formats Roy-Vidar
Feb 22, 2005 Thread starter #3 mystuff Programmer Apr 30, 2004 86 US OK, Thanks. I got it to work. Upvote 0 Downvote