code to change color of negative cell

's Computer Specifications

I am creating a table with percentages and I want it to make the
negative %s red. How would I code/format for this?

Thanks,
Jackie

's Computer Specifications

do a custom number format (format=>cells=>Number Tab then Custom)

0.0%;[Red]0.0%

--
Regards,
Tom Ogilvy

"(E-Mail Removed)" wrote:

> I am creating a table with percentages and I want it to make the
> negative %s red. How would I code/format for this?
>
> Thanks,
> Jackie
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change background color based on cell value in vb?? Current code notworking...	Naji	Microsoft Excel Programming	1	11th Feb 2008 10:15 PM
Why excel cell color did not change after formatting and VBA code?	=?Utf-8?B?Q2FzZXkgV29uZw==?=	Microsoft Excel Discussion	7	8th Nov 2007 05:20 PM
Change the interior color of a cell - Code Review	Tiny Tim	Microsoft Excel Programming	6	17th Dec 2005 09:49 PM
Color change for a negative value	=?Utf-8?B?SUlmIElzc3Vl?=	Microsoft Access Reports	3	14th Jun 2005 09:43 PM
Re: Color the cell with negative values	Frank Kabel	Microsoft Excel New Users	4	29th Jan 2004 10:41 PM