| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can I use the 'fill color' as part of a formula
I have a range of cells with numerical values thant are checked off regulary.
So I can still see the value I indicate that a particular number has been used by 'filling in the cell'. How do I write a formula that can omit all data that has not been filled in??????????? |
|
#2
|
|||
|
|||
|
Have a look here for help working with colors:
http://www.cpearson.com/excel/colors.htm -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "scottnoidea" wrote in message ... I have a range of cells with numerical values thant are checked off regulary. So I can still see the value I indicate that a particular number has been used by 'filling in the cell'. How do I write a formula that can omit all data that has not been filled in??????????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill of formula | Excel Worksheet Functions | |||
| Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
| Fill formula question | Excel Worksheet Functions | |||
| Possible? formula in one cell can fill another cell | Excel Worksheet Functions | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
Linear Mode
