excel course tate modern - negative figures

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Negative figures

excel course tate modern - Negative figures

resolvedResolved · Low Priority · Version Standard

Muhammad has attended:
Excel Advanced course

Negative figures

In excel if I entered a negative figures how can it apprears in red and in bracket which should be default .

e.g, if I entered -543.00 in any cell it looks like (543.00) apprears in red

Please advise

RE: Negative figures

Hi Muhammad,

You can use Conditional Formatting to achieve this result.

Select all cells by clicking the header/column row between A and 1. Or press Control+A on the keyboard. All cells should be selected.

Now go to Format -> Conditional Formatting...

Here you can have up to 3 conditions. The first one gets added automatically, you just need to insert the values.
Drop box 1: Keep as 'cell value is'
Drop box 2: Change to 'less than'
Field 3: type 0

Then press the 'Format' button, select Red colour, then press OK, and OK again to exit Conditional Formatting box.

Now whenever you enter or calculate a value, the colour should be Red if the value is less than 0.

Hope this helps.

Regards, Rich

RE: Negative figures

Well, I understand how to bring the negative figure into the cell and how it become red but basically my question was that always " this negative figure should come in the bracket" which indicates that this is negative figure

Please advise

Edited on Tue 27 Nov 2007, 14:16

RE: Negative figures

Hi Muhammed, Just to put my twopence worth in, to do this you could also create a Formatting operation which will recognise that the value is negative and would format it in the style that you choose. Try following these steps; In your chosen worksheet select the area that you wish this Custom Formatting to appear, if it is the entire Worksheet, use the select all command (CTRL+A), go to the Menu option Format, Cells and in the Number tab, choose the Custom option; in the "Type" text box enter the following: #,##0.00;[Red](#,##0.00) this assumes that you will be entering decimal places, if this is not the case leave the .00 off, but you do need the hash signs (#) and the 0 (zero) before the decimal point, note it will assume you want to put the comma separation in your thousands, if not leave it out. I hope that helps regards Pete.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.08 secs.