Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Total column changes colors when total equals sum of other columns
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing colors of a formula total. | Excel Discussion (Misc queries) | |||
disable Total and/or Sub total for a single column | Excel Worksheet Functions | |||
If cell equals, give total of another cell | Excel Discussion (Misc queries) | |||
in excel just want to add 4 columns and total in next column | Excel Worksheet Functions | |||
XL formula - total of row = total of column | Excel Worksheet Functions |