Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |