Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 03:29 PM
Eric S.
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 05, 03:31 PM
N Harkawat
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 03:42 PM
Eric S.
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 03:44 PM
RagDyeR
 
Posts: n/a
Default

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




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
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:48 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017