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

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

Hi again, i found it my self :D

"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

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