conditional formula

[restes]

is it possible to include and or exclude a number/cell from the result of a
formula based on format of cell?

ie if the shading is anything other then no fill i want to not add it into
toal but is it is no fill have it included in formula.

 

[John C]

There are VBA choices to choose from, if you search I'm sure you will find
it. However, if the shading is based on some condition, it is usually easier
to just some based on the same conditions...

 

[Pete_UK]

Chip Pearson has some notes (and a download) here:

http://www.cpearson.com/excel/colors.aspx

which explains all about counting and summing by colour.

Hope this helps.

Pete

 

[restes]

where would i search?

There are VBA choices to choose from, if you search I'm sure you will find
it. However, if the shading is based on some condition, it is usually easier
to just some based on the same conditions...

 

[John C]

If you are accessing these groups from the Microsoft website, you could
search under Excel--> Programming.
also, you might take a look at Pete's response.