ExcelBanter - Excell 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excell 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/111998-excell-2003-a.html)

kcc

Excell 2003

[1] How does one show negative numbers in red color?
[2] How does one "paint" cells/fields?

Gord Dibben

Excell 2003

1. FormatCellsNumberNumber. Select the "negative numbers" format.

2. Don't understand "paint".

Color the cells? FormatCellsPatterns.

OR just click on the PaintCan Icon on the formatting toolbar.

Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 08:43:03 -0700, kcc wrote:

[1] How does one show negative numbers in red color?
[2] How does one "paint" cells/fields?

All times are GMT +1. The time now is 04:23 PM.