View Single Post
  #1  
Old June 15th, 2004, 03:25 PM
BenJAMMIN
external usenet poster
 
Posts: n/a
Default Auto Sum + Conditional Formatting

I would like to take one cell and have it with the Auto Sum feature. Here's the catch: I have applied a simple Conditional Formatting to a number of cells. The formatting is setup for blank formatting: equal to =""
There is nothing between the quotes, which tells the formatting that if there isnt anything in the cell, then give the cell a color. If ANY value is placed in the cell, take away the color.

So with that said, is there a way to have the Auto Sum feature add up those cells and tell me how many that are left that need a value? For example, if there are 60 cells to begin with, and 32 of them have had a value placed in them, the Auto Sum cell would display the number 28.

Any ideas on how to get this to work or something similiar?
Thanks