#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default FOrmat cell


HI,

I want to format excel cells in my workbook in away where if i enter
negative figures, cell colour or font colour becomes RED and for all
possitive figures it is green.

Can i kindly get some advice.

Thanks,
--
kaushi
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 284
Default FOrmat cell

Kaushi

Format the area you are making your entries the green font color you like.
Then goto FormatcellsNumber and select the red (1234.10) select the number
of decimal places you want and the thousands separator (,) if you want that.
This will put all negative numbers in red with (...). If you don't want the
parans you can now click on the custom catagory and remove them in the
"types" window.

Hope this helps

Mike Rogers

"Kaushi" wrote:


HI,

I want to format excel cells in my workbook in away where if i enter
negative figures, cell colour or font colour becomes RED and for all
possitive figures it is green.

Can i kindly get some advice.

Thanks,
--
kaushi

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 245
Default FOrmat cell

This can be done with custom formatting of cells.

If you don't understand how to create a custom number format read the
following site,

XL2003 How to create
http://office.microsoft.com/en-us/ex...CH010036911033
XL2007 How to create
http://office.microsoft.com/en-us/ex...CH100870371033

Once you understand how to create a custom format, keep reading.


The choice of colour readily accessed by name is limited [BLACK], [BLUE],
[CYAN], [GREEN], [MAGENTA], [RED], [WHITE], [YELLOW]. However, there is a
[COLOR n] option that opens up more choices.

Using GREEN, as below gives lime green and is difficult to read.

[Green]0;[Red]-0

Using [Color n], my opinion is the best available green shade is 10:

[Color10]0;[Red]-0

The above does nothing fancy in the way of formatting. Zero and positives
are green. Negative numbers are red. You may wish to use a different format
for your numbers (e.g. to pick of commas in thousands). The following will
do this:

[Color10]#,##0;[Red]-#,##0

This site will give you further help:
http://www.ozgrid.com/Excel/CustomFormats.htm


Run the following macro on a blank sheet to pick you n colour

Sub ListNColours()
'run in a blank sheet
On Error GoTo ListNColours_Exit
For i = 1 To 56
Range("A" & i) = i
Range("A" & i).Interior.ColorIndex = i

Next i

ListNColours_Exit:
End Sub


--
Steve

"Kaushi" wrote in message
...

HI,

I want to format excel cells in my workbook in away where if i enter
negative figures, cell colour or font colour becomes RED and for all
possitive figures it is green.

Can i kindly get some advice.

Thanks,
--
kaushi


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default FOrmat cell


Just to in Format Cell Number Custom and paste this function over
there ....

[Green]0;[Red]-0


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99328

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
cell format - remove cell format pattern without effecting colors Bas Excel Discussion (Misc queries) 1 March 23rd 09 03:54 PM
Can cell format come from and change with reference cell format jclouse Excel Discussion (Misc queries) 1 November 29th 06 04:20 AM
How do I copy data in single cell format to a merged cell format Paul Excel Discussion (Misc queries) 1 June 27th 05 11:00 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"