Counting cells that have turned green

[plrose]

1. I would like to know if I can have a formula that counts or totals the cells in a column that have turned green or have a number greater then zero.


2. I am entering data on one chart that populates a second chart that I then print. In the chart that I print all of the cells have zeros in the cell that I have not entered data, how can I have the chart not display the zero’s

Peter

[plrose]

I have figured out how to do question 1 if you could help me with question 2 i would appriciate it

Peter

[ColHOLM]

Please Login or Register  to view this content.

substitue the cell you need for the A2 I typed

[plrose]

Thanks - but that is not what i am look for i will attach the spread sheet

I enter by information into the bottom chart which populates the top chart. What i would like to do is make the Zeros in the top chart disappear unless data from the bottom chart inputs

Thanks Peter

[plrose]

I need to hide or remove the zeros from the top sheet. any input would be helpful

Peter

[martindwilson]

tools/options/view uncheck zero values

[plrose]

Thank You Martin

i spent hours trying to remove the zeros Excel Help was no help at all

Peter

[shg]

If you want to suppress display of zeros only in the table (as opposed to everywhere), you can format those cells as General;-General;

Don't forget the trailing semicolon.