NEW Spreadsheet: 2.4b w/ Daily Summary - Page 4

TStokes · #31 07-26-2005, 06:03 PM

My daily summary just started acting up today. It shows how many tourneys I have played but it does not show if I have made money or not. Anyone know how to fix this?

astarck · #32 07-26-2005, 06:12 PM

[ QUOTE ]
My daily summary just started acting up today. It shows how many tourneys I have played but it does not show if I have made money or not. Anyone know how to fix this?

[/ QUOTE ]

I knew it would only be a matter of time until this happened to someone. What is happening is I have to format each cell conditionally. So when a cell equals 0 I have it white-out. This works great for the T# but not so great for the profit because you could end up right on 0.

As far as a work around you can click on the cell and under the Format tab click on "Conditional Formatting", remove the condition about it equalling 0 and whiting out.

The permanent fix would be to link the conditional formatting for the profit column with that of the T# but I don't know if this is possible.

EDIT - You broke even on the day.

TStokes · #33 07-26-2005, 06:25 PM

are you saying this only happens when I break even on a given day?

astarck · #34 07-26-2005, 06:26 PM

[ QUOTE ]
are you saying this only happens when I break even on a given day?

[/ QUOTE ]

Yes. Whenever the cell is 0 it is white, so if you don't play or breakeven it is gone.

TStokes · #35 07-26-2005, 06:29 PM

alright thanks I was freaking out I thought I had screwed up something in the sheet.

astarck · #36 07-26-2005, 06:35 PM

No problem. Did you change the formatting and was the cell 0 (I'd like to be 100% sure that that is the problem).

TStokes · #37 07-26-2005, 06:44 PM

I asked the question right as I was starting a session so I was going to see if it changed after this. I did not get a chance to test out the changes you were asking about.

TStokes · #38 07-26-2005, 06:47 PM

if you want though tonight I could test it out to see if what you were suggesting works

astarck · #39 07-26-2005, 08:41 PM

[ QUOTE ]
if you want though tonight I could test it out to see if what you were suggesting works

[/ QUOTE ]

If you are talking about my workaround solution I know that works, so don't bother testing that. The only thing I would like to know is that if your profit for the day does move away from 0 that the cell is correctly showing. Just keep on playing and making money. [img]/images/graemlins/grin.gif[/img]

A_PLUS · #40 07-26-2005, 09:22 PM

Wow, I work in excel for a living, and.....awesome (openly wimpering). I have a speadsheet crush on someone [img]/images/graemlins/blush.gif[/img]