Eric S.

Posts: n/a

Change Text-color depenting on SUM-function

Hi

Im using Excel to sum a number of cells, A2:A10 to cell A11

I want the text color in A11 to be red if the sum is negative and black if
its positive.
Is there an esay way to do this using an IF-statement or do i have to make
some script?

All help will be much appreciated

Thanx

/Eric

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Change Text to a number	jennifer	Excel Worksheet Functions	1	April 27th 05 08:47 PM
UDF and Calculation tree	Ken Wright	Links and Linking in Excel	1	February 6th 05 04:58 PM
Ignore text Function	Grant	Excel Worksheet Functions	3	February 3rd 05 10:38 PM
how do I change the text case of imported data in excel?	ArtLene	Excel Discussion (Misc queries)	1	January 26th 05 07:08 AM
Adding text before a function	Eric	Excel Worksheet Functions	1	November 3rd 04 06:57 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us