| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM numbers of a certain font color
I am making a sheet of customers that have contracts to build objects. In
column A, there is a list of prices that are paid and not paid. The paid items are formated in red font color. Column B is the amount we have paid them. Is there a way to formate colum B so that when i change a number to red in column A, it will automatically update with the new SUM in colmn B? Hopefully not too confusing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font color for negative numbers | New Users to Excel | |||
| Font color for negative numbers | New Users to Excel | |||
| Can I total only numbers with a specific font color? | Excel Discussion (Misc queries) | |||
| calculate numbers based on font color? | Excel Worksheet Functions | |||
| How do I display negative numbers in a differnt color font? | Excel Discussion (Misc queries) | |||
Threaded Mode
