In Addition to my last question

  • Thread starter Thread starter brett4098
  • Start date Start date
B

brett4098

which was- I have the normal three sheet workbook open. I was wonderin
if on one page i fill (color) a certain cell and could have, on anothe
page, a formula summing the number of cells that i've highlighted in
certain color?--Instead of the color idea, could i calculate if i adde
a row and put an X in a cell
 
Brett
Assuming your X's are in row A of sheet1, you could count them with the following formula

=COUNTIF(Sheet1!A:A,"X"

Or in regard to your original idea, Chip Pearson has some good info on counting highlighted cells at

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

Good Luck
Mark Graesse
(e-mail address removed)

----- brett4098 > wrote: ----

which was- I have the normal three sheet workbook open. I was wonderin
if on one page i fill (color) a certain cell and could have, on anothe
page, a formula summing the number of cells that i've highlighted in
certain color?--Instead of the color idea, could i calculate if i adde
a row and put an X in a cell
 
Back
Top