Remember Me?

#1
May 23rd 05, 03:29 PM
 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

#2
May 23rd 05, 03:31 PM
 N Harkawat Posts: n/a

Take a look at Format--conditional formatting..

"Eric S." <Eric wrote in message
...
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

#3
May 23rd 05, 03:42 PM
 Eric S. Posts: n/a

Hi again, i found it my self

"Eric S." skrev:

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

#4
May 23rd 05, 03:44 PM
 RagDyeR Posts: n/a

Select A11.

<Format <Conditional Format

1st box = "Cell Value Is"

Expand 2nd box and choose "Less Than",

Enter zero in 3rd box,

Click on Format and make your choices,,
<OK <OK
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Eric S." <Eric wrote in message
...
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jennifer Excel Worksheet Functions 1 April 27th 05 08:47 PM Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM Grant Excel Worksheet Functions 3 February 3rd 05 10:38 PM ArtLene Excel Discussion (Misc queries) 1 January 26th 05 07:08 AM Eric Excel Worksheet Functions 1 November 3rd 04 06:57 PM

All times are GMT +1. The time now is 11:08 AM.