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???????????

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???????????