|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 23rd, 2005, 03:29 PM
|
|||
|
|||
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, 2005, 03:31 PM
|
|||
|
|||
|
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, 2005, 03:42 PM
|
|||
|
|||
|
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, 2005, 03:44 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
| Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
| Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
| Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |
| Rich Text Spell Check | Stephen Lebans | General Discussion | 0 | July 27th, 2004 01:03 AM |
Linear Mode
