Total column changes colors when total equals sum of other columns

I have set up a column that will have invoice total.  Then have other columns 
that are the "parts" of the total.  IE: total invoice  $100.00 (I type in 
this total).  Next columns 3 columns include the parts that equal the total 
invoice.  Say like $50, then $30, then $20.  I want the total (ie $100.00) to 
display in "red" until I enter the next 3 columns and then it will change to 
"black font color" only if my totals in the 3 columns equals $100.00
0
newstacy (1)
4/21/2007 7:44:02 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
425 Views

Similar Articles

[PageSpeed] 14

Alright, if I get what your saying this should work. Suppose you have your 
total in Cell A10. Set the color to red yourself. Then follow these steps.

1) Select cell A10
2) Go to---- Format ---> Conditional Formatting
3) Change the "Cell Value Is" to "Formula Is"
4) Type in this formula exaclty =A10=SUM(B10:D10)
5) Change the format to whatever color you want (Black in your case)
6) Press OK

Now if your totals in Cells B10:D10 equal 100, the font will change from red 
to black. Let me know if this helps.

"newstacy" wrote:

> I have set up a column that will have invoice total.  Then have other columns 
> that are the "parts" of the total.  IE: total invoice  $100.00 (I type in 
> this total).  Next columns 3 columns include the parts that equal the total 
> invoice.  Say like $50, then $30, then $20.  I want the total (ie $100.00) to 
> display in "red" until I enter the next 3 columns and then it will change to 
> "black font color" only if my totals in the 3 columns equals $100.00
0
AKphidelt (33)
4/21/2007 8:00:05 PM
Reply:

Similar Artilces:

An XML question
I would like to produce the following output based on my XML file: My Album (2005) Elapsed Time (hh:mm:ss): 00:07:00 Song 1: title1 Length (hh:mm:ss): 00:02:30 Song 2: title2 Length (hh:mm:ss): 00:02:15 Song 3: title3 Length (hh:mm:ss): 00:02:15 ===== <album> <general> <title>My Album</title> <year>2005</year> </general> <content> <song> <songTitle>title1</songTitle> <songLengthInSeconds>150</songLengthInSeconds> </song> <song> <...

Changing View For Public Folders
Hello, I am looking for a way to change the view of the Public Folders from the default Detail view to a custom Icon view. If anyone knows of a way to accomplish this, I would be greatly appreciative. One of our customers is looking to have this setup. Thanks. -b To force users to see a custom view when they open a public folder:=20 -- Create the custom view, choosing the "On this folder, visible to = everyone" option.=20 -- Choose View | Current View | Define Views. Select the desired view, = and click Publish. At the bottom of that dialog, check the box for "Only = sh...

Excel cut/Paste Problem: Year changes after data is copy and paste
I am using Excel 2003, and here is the problem. I have an Excel sheet that contains financials. Different departments need different sections of the data, so I copy and paste out only those sections they need and paste it into a new Excel sheet. The colums are broken up into dates, and formated to show date-year (Dec-05). For some reason, when I copy and paste sections, the date will change, for example Dec-05 will change to Dec-01. I have to go thru and manually correct all the dates. Can anyone tell me what is causing this? . .. maybe the cells in the New worksheet are preset to a c...

Manual change of a fixed asset cost basis should use User Date
The manual increase or decrease of the cost basis of an asset uses the computer system date to record the transaction date. Companies that prevent computer system dates from being changed cannot record the change in cost on the correct date. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree"...

Moving a value in Column D
I have a spreadsheet with values in a couple of cells in Column E. The rest of the cells are blank. I would like a macro that would move the value of any cell containing data (non empty cells) four cells backwards and two cells downwards to Column A. Is there a macro that would do this. -- Message posted via http://www.officekb.com Sub MoveIt() Dim rCell As Range For Each rCell In Columns("E") _ .SpecialCells(xlCellTypeConstants) rCell.Offset(2, -4).Value = rCell.Value rCell.ClearContents Next rCell End Sub HTH -- AP "mohd21uk via OfficeKB.com" <u20517@u...

Stop changing of languages in Word 2003 when typing letter.
While typing a letter in Word 2003 it changed from English to what looked like Arabic language. I have rebooted 3 times and started over and still the same occurs. I even copied what I had in English to an email in Yahoo and sent it to myself and rebooted. Came back to that same email and copied it to a new email that I started to myself, and when I started typing it would only type in what looked like Arabic language. This happened to me once a couple of weeks ago, but never occurred again till now. What do I do? In the Language dialog box, turn off the option to autom...

Totals on Sales Inquiry native windows
We would like to have the totals on the Sales Inquiries: Transaction by Customer Transaction by Document Sales Documents Sales Items Today we can retrieve this information in separated inquiries and reports, be we would like to heve a easier way to see this totals... The same suggest can be applied to Smartlist. If possible, you can create a tool to sum a field after you make a filter I created a screen where you can see all sales, separated by day of week, and week of year, and totals YTD,MTD and WTD, but I am not able to have the same information grouped by item number, for example.....

BrowseForFolder
Hi; probably not the correct group (win32?) but i would like to know how i can change the text in the blue title of the BrowseForFolder form from MFC. Now, it always says 'Browse For Folder'. Setting the title changes the text immediately above the directory browser but i would like the change the window title, for localization purposes. best regards bav Hi, http://msdn2.microsoft.com/en-us/library/yhczy8bz(VS.80).aspx HTH, "bav" <baudewijn.vermeire@skynet.be> wrote in message = news:46b78a80$0$13852$ba620e4c@news.skynet.be... > Hi; > probably not the c...

Re: fuction to copy Column a and b to comment or colum c?
Please help!!! I would like to know a fuction or a way to just recop what ever is in colum a and c to comment in colum d. Is this eve possible? If not maybe a fuction to put values of colum a and c t colum d. Please keep in mind this would prevent me from typing again. Thanks!!! -- Message posted from http://www.ExcelForum.com You can concatenate the values in A & C in column D with a formula: =A1&C1 or =A1&" "&C1 if you want those values in a comment, you'll need a little code. This is a sub (not a function): Option Explicit Sub MakeComments() Dim...

total cost on report
I have areport with a cost field that I would like to total that collum at the end of the report. How do I do this ? do I need to create another field (total) please help thanks, jettro Jettron wrote: >I have areport with a cost field that I would like to total that collum at >the end of the report. How do I do this ? do I need to create another field >(total) The usual way is to use a text box with an expression like: =Sum([cost field]) -- Marsh MVP [MS Access] I'm in design view of the report, where do I insert this expression? I clicked on page footer to insert thi...

Standard Cost Changes:'Do not Rollup through Where Used' functiona
There is a major issue that needs to be resolved regarding the way this functionality works. In a nutshell, the program is storing the global BoM tree changes that would have happened from a rollup when 'Do Not Rollup Where Used' was checked and it is applying these on the next rollup--even if the part # being changed in the new rollup is completely unrelated to the previous one. Let's say, for example, that you just created a brand new part #, with no relationship to ANY BoM. It is a Standard Cost (FIFO Periodic) item. You go to enter Material and Overhead costs for this...

Setting ID# to 1 & Total on bottom of query result
Hi, I have 2 separate questions. First how do I set the ID# to 1 for the first record. I copied my whole database including queries and forms which were 2009 records and changed the titles to 2010. I did a "compact and repair" to the 2010 database. But when I start to enter records for 2010 the ID# is 2550. How can I reset the ID# back to start at 1? On many of my queries I have the results be for example 28 Caucation, 43 African American, 65 Hispanic, 4 Asian, 2 Native American. I need these numbers separate like they are but I would like a total line at the bottom...

Change the assigned chart number
If you use the Macro Recorder and select several charts (in the same worksheet) in secession you can see that Excel has assigned a name to each chart such as Chart 1, Chart 2, ect.. Is there a way to rename say Chart 15 to Chart 3, assuming Chart 3 does not already exist? -- Al Eaton aleaton@bak.rr.com To manually rename a chart object: Hold the Ctrl key, and click on the chart to select it Click in the Name box, to the left of the formula bar Type a new name, or edit the existing name Press the Enter key To programmatically rename a chart object: ActiveSheet.ChartObjects("Ch...

macro
I have several columns in an income sheet. One column has a sum at the bottom. I want to be able to run a simple macro that will copy the last row of formatted cells, just above the sum total, and insert it as a new row just above the sum total so another line of data can be input. But I want the sum total to sum also the newly inserted row. Presently I can't figure out how to do it. Example A B C 1 24 Oct Dollars In $100 2 25 Oct Dollars out $25 3 Total ...

How to make chart columns thicker
Hi I am using excel 2007. I am trying to create a chart with 20 weeks in the x axis. The chart type is Column, clustered column. The chart displays two lots of data. The problem is, the columns are displayed as very thin, in fact they're little more than lines, yet there is a lot of room on the chart for them to be much thicker. How do I make the columns thicker? The chart just looks daft at the moment. Thanks for any help Colin Ok, brain in gear now, I've worked out what was wrong. The problem was that the x-axes was recognising the data as a date. I told it that it was text by ...

How do I change the author of a publication
I was given a publication to use for a newsletter and have since completely changed the design but would like to continue using the said file - the only thing is that it lists the 'other' author - how do I change this to reflect me as the author of the newsletter? This information is probably in "Business Information" if you are using 2007. Edit menu... Earlier versions it is known as *Personal Information*, also in the Edit menu. -- Mary Sauer http://msauer.mvps.org/ "Ausgirl09" <Ausgirl09@discussions.microsoft.com> wrote in message news:54EA4CE3-F8...

Printing Long Columns
I have a simple worksheet with order numbers in column A and corresponding completion dates in column B. Since there are over 1,000 orders, it takes many pages to print the sheet, with a great deal of paper wasted on the blank area to the right of the two columns. Other than the tedious process of cutting and pasting, is there a way to arrange the information into multiple multiple columns across the page? Try this example on David's site Charlie http://www.mvps.org/dmcritchie/excel/snakecol.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Cha...

query issues
I am having trouble figuring something out and hoping someone out there might be able to help. I have built an Access database for a hospital education department to track education activities that employees have taken and/or need to take. I have built into the structure a means of requiring a specific job code to take a specific activity, or employees from a specific department to take an activity. I have tables set up - Employee, JobCodes, Depts, JC_Requirements, and Dept_Requirements. Each employee has a Dept_Num and a JC_Num. These fields are linked to the Dept and JC tables. Each ta...

Changing ruler increments?
Is there a way to change the ruler increments, thereby changing the snap to increments or does it just default to the 16th of an inch only? I'm trying to make all text carrying boxes the same size and can come close but can't snap them into the same size. It's really close enough but I was just wondering if I can make the snaps and nudge increments smaller than they ar Thanks Hi Catt (anonymous@discussions.microsoft.com), in the newsgroups you posted: || Is there a way to change the ruler increments, thereby changing the || snap to increments or does it just default to the 16th...

Excel 2007 changes links in cells
Hello guys, when I enter link to TXT file in the cell (e.g. D:\aa\ss\ko-hs-048-332-09\11ss.txt), for some reason it changes to C:\Users\Eddie\AppData\Roaming\Microsoft\Excel\ko-hs-048-332-09\11ss.txt after some time. It seems to me it's something like Temporary Internet Files in IE... Any ideas how to keep the original link assuming that I haven't changed the location of the file? Thanks, Milan -- Milan Bortel MCP, MCAS, MCTS GOPAS Computer Training Center Brno, Czech Republic Saved from a previous post: A few people have said that this has stopped a s...

Finding Cells that Total a Value
Hello Friends, I need some assistance in solving a problem. I have a spreadsheet with over five hundred lines of transactions. The sum of these transactions are creating a balance on the account. Is there any formula/macro that will help me find the transactions creating the balance? The sum of the account should be zero. To clarify, if we owe client money, there would be a transaction setting up that postive balance then a payment on the account taking it back to zero. There could be multiple transactions and then one net payment. Or we could be due to receive. So at the end of the day, th...

Total Items
Hi - Is there a way to get a total number of items that are about to be tendered, on the POS screen ? Thanks. You can customize the status.htm file. Not sure exactly what the variable is that you want, but I know it cn be done. "NJS" <NJS@discussions.microsoft.com> wrote in message news:538F3CC7-F23D-43C7-8A5A-4319B8688E5B@microsoft.com... > Hi - > Is there a way to get a total number of items that are about to be > tendered, > on the POS screen ? > Thanks. Jason, Send me your email I have already customized this and will forward you. "Jason&qu...

Stacked Column Chart Data Label Connector Lines
I can't for the life of me figure out how to place the data labels for a stacked column chart (# or %) (1) next to the column, then (2) have lines connecting the data value to the proper block of the column. It does it automatically for pie chart labels, but not columns. Anyone have insight into these two issues? Thanks in advance. Not a solution, but explaination: XL won't let you place the labels by design to the side because its possible to place stacked columns next to each other (gap width = 0). This would then make it look like the values were associated with wrong col...

Changing Project Type
I am looking for someone who can help in advice what is the best way, to convert a project type after posting transactions and billing. -- Project Manager ZFP-IT +966503855729 You should put that Project on Hold and close it down. Then open a new Project of the correct Type in the same Contract. Or it can be done in SQL and it would take me most the day to spec how to do that at a buck seventy five! "Sami Hamdonah" wrote: > I am looking for someone who can help in advice what is the best way, to > convert a project type after posting transactions and billing. > -- ...

HOW TO SORT 4 COLUMNS
I HAVE A CUSTOMER LIST THAT I NEED TO SORT IN THIS ORDER, ST (COLUMN G), CITY (F), ZIP (H) & NAME (A). RANGE IS A6:M565. THANKS. VICTOR select data sort and pick the rows you want to sort by, If you want it in VBA then use your macro recorder, but before you record the macro practice on it first, there is nothing more maddenning than having to record he macro 5 or 6 times because of forgetting something. then from the forms button select a command button and assign a macro to it I should explain that I need to sort the criteria in those column and it only allows three. Consequentl...