ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   negative numbers in parenthesis are not clear on excel printout? (https://www.excelbanter.com/excel-discussion-misc-queries/61346-negative-numbers-parenthesis-not-clear-excel-printout.html)

John

negative numbers in parenthesis are not clear on excel printout?
 
positive numbers fonts are darker and easier to read on the printed report? I
would greatly appreciate some help.....

Pete

negative numbers in parenthesis are not clear on excel printout?
 
Do you mean that negative numbers are shown in red (or blue) on screen
but you print them out in black & white and so they appear feinter than
positive (black) numbers? If so, you can change the format using Format
| Cells | Number tab | Custom.

Pete


Dave Peterson

negative numbers in parenthesis are not clear on excel printout?
 
Maybe it's just a problem with the font size that's printing.

If you can't change the font size (report won't fit on the paper when you do),
maybe you could use format|conditional formatting to bold those numbers that are
negative.

John wrote:

positive numbers fonts are darker and easier to read on the printed report? I
would greatly appreciate some help.....


--

Dave Peterson

gandhi318

negative numbers in parenthesis are not clear on excel printout?
 

Hi,
You may try conditional formating from Format Menu
First give conditional formating to first cell of your data or range or
A1 cell
If Cell Value is less than 1 format it in different colour back ground,
less fort size, colour display etc
Then copy this conditional formatted cell to all your data or entire
worksheet as you please


--
gandhi318Posted from - http://www.officehelp.in



All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com