Search:

Type: Posts; User: Lou Sander; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    18
    Views
    1,155

    I am re-thinking what I need here. There is more...

    I am re-thinking what I need here. There is more to it that I have been able to specify so far.

    In the meantime, I'm getting ready for a new lottery pool that starts in July. I have to start a...
  2. Replies
    10
    Views
    173

    Fixed it! I put a dollar sign before the C. As...

    Fixed it!

    I put a dollar sign before the C. As in =$C6=""

    Everything seems to work perfectly now.
  3. Replies
    10
    Views
    173

    I did remove all conditional formatting before...

    I did remove all conditional formatting before re-doing it. The results are strange, per the image below. They are even stranger in other parts of the worksheet.

    43834
  4. Replies
    10
    Views
    173

    After Step 2 and before Step 3, I am tempted to...

    After Step 2 and before Step 3, I am tempted to Clear Rules > Clear Rules from Selected Cells. That might clean up some trash. Whadda ya think?
  5. Replies
    10
    Views
    173

    Conditional Formatting (Excel 2010)

    This is driving me crazy.

    In the range D6:AD175, I want the cells in columns D through AD to be have a gray fill color if column C in the corresponding row is blank (it will either be blank or...
  6. Very nice! Thank you. I did it, and it works....

    Very nice! Thank you.

    I did it, and it works. Unfortunately, it seems to have clobbered my list of recent documents. One of these was Normal.dotm.

    I've recovered from that OK, though.
  7. Changing layout in the Quick Styles Gallery

    I think the thing depicted below is called the Quick Styles Gallery, but I can't find its name anywhere.

    43525

    It's a lovely tool, but I need to fix it.

    I almost never use Headings, but I...
  8. Replies
    2
    Views
    107

    [SOLVED] Thanks. I thought I remembered that the codes...

    Thanks. I thought I remembered that the codes updated when the file was saved. I guess it was "printed".
  9. Replies
    2
    Views
    107

    [SOLVED] Automatically put filename in footer

    I'm still not up to speed in Word 10.

    When I create a new document, I want its Footer to contain the filename, a page number, and the date. I've achieved most of this through modifying...
  10. Replies
    18
    Views
    1,155

    The more I ponder this, the thornier the...

    The more I ponder this, the thornier the situation becomes. Best will be if the gurus can see the whole workbook. I've put a depersonalized copy at a place where anyone can download it....
  11. Replies
    18
    Views
    1,155

    Thanks! There's no drawing tonight (Monday), so...

    Thanks! There's no drawing tonight (Monday), so I'll test the code tomorrow when there is one.

    I will also ponder your question. It is an important one, since updates regularly occur throughout...
  12. Replies
    18
    Views
    1,155

    Good stuff! A cell named CountOfShares DOES...

    Good stuff!


    A cell named CountOfShares DOES hold the latest number of shares.
    There's a worksheet named !Participants, and the CountOfShares cell is on that sheet. When someone sends money,...
  13. Replies
    18
    Views
    1,155

    I've just gotten around to looking at this. I'm...

    I've just gotten around to looking at this. I'm thinking it might be close, but maybe no cigar.

    CountOfShares changes independently of the drawings, depending on when people buy new shares....
  14. Replies
    20
    Views
    935

    [SOLVED] Maudibe's solution seems to be working fine, and...

    Maudibe's solution seems to be working fine, and has handled all of the date transitions it has been faced with. I'm going to assume that it ALWAYS works, and close this thread.
  15. [SOLVED] That does it! I'll use Special Formatting for...

    That does it! I'll use Special Formatting for now, and think more about CF and fill colour.

    The world of Excel is an endless one, and fascinating.
  16. [SOLVED] Very interesting! This variety of special...

    Very interesting! This variety of special formatting is new to me.

    It definitely changes the color when the cell contains something higher than the trigger. It definitely does NOT change the font...
  17. [SOLVED] More... The font to which the cell changes...

    More...

    The font to which the cell changes seems to be Cambria 10 point. That is the "Headline" font that shows up when I look at the Fonts for my current Theme. I don't know much about themes,...
  18. [SOLVED] Conditional Formatting - Changing Font Color Changes Font Face

    I have a worksheet with a column of cells whose font color changes if the cell has a value above 95,000,000. The cells are formatted as 10 point Verdana, with their color AUTOMATIC.

    The...
  19. Replies
    18
    Views
    1,155

    Lottery31.xlsx - 4.60MB Lottery31.xlsb -...

    Lottery31.xlsx - 4.60MB

    Lottery31.xlsb - 1.59MB

    I'd have to delete about 200 names and other contact information, but I don't think that would take too long.
  20. Replies
    18
    Views
    1,155

    I'd like to make the whole workbook available,...

    I'd like to make the whole workbook available, but it's over 5MB and contains a lot of personal information about players. I'm tempted to mask the personal information and put the whole thing up on...
  21. Replies
    18
    Views
    1,155

    Capturing a count that later changes

    This is, at least for now, the last unsolved puzzle in my lottery workbook.

    My lottery pool sells shares on an ongoing basis. My workbook keeps track of the number of shares sold in a cell named...
  22. Replies
    20
    Views
    935

    [SOLVED] Yeah, maybe, but not as talented as Willie! That...

    Yeah, maybe, but not as talented as Willie! That website project just arose from nowhere and absorbed my attention for months. Like the lottery workbook, it's the product of a LOT of refinements.
    ...
  23. Replies
    2
    Views
    208

    That does it! I guess I could have figured it...

    That does it!

    I guess I could have figured it out myself, but Excel 2010's conditional formatting is still something of a mystery to me.
  24. Replies
    20
    Views
    935

    [SOLVED] I THINK most of our players are in it for the fun...

    I THINK most of our players are in it for the fun of it, plus the hope and attitude boost that comes from having a shot at winning a bundle. I, myself, get a huge amount of fun out of it. Continual...
  25. Replies
    20
    Views
    935

    [SOLVED] That $100 million stuff is great, but since we...

    That $100 million stuff is great, but since we have so many players, each of us takes home a lot less. About $600K after taxes, typically, for a $100M cash jackpot. Not a bad payday, but not enough...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4