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
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.
