| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations based on cell colour
With Excel 2007, is it possible to create a formula that will sum,
based on the shading or colour of a cell ? I'm looking for an easy way to pick up items that have been billed and calculate the balance outstanding without having to change the formulae all the time. Regards Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i autofill a cell a certain colour based on it's value? | Excel Worksheet Functions | |||
| Calculations based on cell value | Excel Worksheet Functions | |||
| Calculations based on adjacent cell values | Excel Discussion (Misc queries) | |||
| Colour Cell based on Content | Excel Worksheet Functions | |||
| How do I set a colour to 4 cells based on the value of a cell | Excel Discussion (Misc queries) | |||
![Fred[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
