Search results

  1. T

    Conditional formatting based on matching cell to any of many values

    Hello. I'd like to apply formatting to a cell, let's say A1, if the value in A1 equals the value in any cell in a range, such as A26:Y50 . So, for example... assume that cell A1 holds the numeric value "156". If 156 appears (cell value, not a portion) anywhere in A26:Y50 , I want the...
  2. T

    Safecracker game

    spikepl... thanks, but.. huh???
  3. T

    Safecracker game

    Hello all. Here's the backstory: I'm in the process of putting together a series of clues, physical challenges and locked 'treasure boxes' and the like as a series of 'quests' for my grandkids (aged 10 and under). I have cryptex-type locked items where they have to figure out the clues to the...
  4. T

    Registry Cleaners

    Galaxiom: Thanks for the input. My feeling has been that if the registry cleaners were truly so great, we'd see much more on them in the popular industry magazines and online articles. What I found was a number of opinion pieces that, surpirsingly, all sounded alike and came to similar...
  5. T

    Registry Cleaners

    A couple friends of mine are trying to sell me on the idea of a registry cleaner to speed up my laptop... a desirable goal, by the way. However, in doing some research, I'm finding precious little information on these programs. Plus, the "reviews" sites concern me as they seem to be either...
  6. T

    Excel incrementing up for no reason - ARGH!

    Thanks. I have no idea whatever what floating-point arithmetic is, but I'll take your word for it that it's related. I've used ROUND to get around this numerous times and it indeed does work. It's extremely irritating that I'll have to remember that for every case in which I use VLOOKUP...
  7. T

    Excel incrementing up for no reason - ARGH!

    Hello. Any help will be GREATLY appreciated. I have attached an excel file in .xls format so I could post it, but I am working in v.2010. The file shows, in column F, formulas that add .01 to the value in the cell above, but starting with the 100 in E1. Column G shows the value of the cells...
  8. T

    "Jeopardy" in Excel and Powerpoint

    Thanks very much. I'll check it out.
  9. T

    "Jeopardy" in Excel and Powerpoint

    Hi all. I have set up a "Jeopardy"-type game show board in Powerpoint for my students. I would like to include scorekeeping as well. I have set up in Excel three cells for scores, and macros to increment those cells by different point values, applying those macros to objects so I can click to...
  10. T

    Conditional formatting based on cellpointer position?

    Thanks for the reply. Yes, active cell. But, what I want to do is click on a cell containing a value, and have cells in a specified range that contain that same value be formatted while that value is selected. So, for example, if I click on a cell containing the number 23, I want all cells in...
  11. T

    Conditional formatting based on cellpointer position?

    I have searched and searched for this subject and can't seem to find anything on it. Is there a way to set up conditional formatting based on the value in the cell that the cellpointer is on? In the alternative, is there a formula or function that would tell me the value of of the cell where...
  12. T

    Timer in Excel - for testing speed of entry

    Hi all. Been a while since I've been on. I'm trying to create a visible timer that will START when a macro button is selected and STOP when entry is made into a particular cell with an ENTER key press. I'm measuring length of time transcription takes but, in the meantime while I learn this...
  13. T

    Print Preview screen layout - 2010

    Hi all. I looked and looked for this and can't find a thing on it. I'd like to know if I can edit the layout of the print preview screen. Half the screen is taken up with the MS Word 2010 stuff, and the actual document preview only covers half the screen. Is there a possible way to reduce...
  14. T

    (XP) - Folder windows - blue bar on the left

    Wow. That simple, huh? Who would've imagined? THANKS!
  15. T

    (XP) - Folder windows - blue bar on the left

    I am working in XP. Whenver I open a file folder window, there is a vertical blue bar on the left that contains folder and navigation information. This is a standard format for this version. Is there any way to get rid of that bar, or at least hide it? THANKS.
  16. T

    Can anyone help me with this tab issue.

    How did you add the border? Were you able to undo and have your desired setup restored? Can you post the file?
  17. T

    Anyone understand multiple regression output?

    I did a regression analysis in Excel... and I don't understand the results. I have six independent variables, but when I look at the p-values two of them seem to have too much influence on the results... so I ran it again without those two. The Significance F and t-stat is what I'm told I need...
  18. T

    ARGH! Wrote over word doc

    I have specific naming conventions for my files. When saving for the first time, I get the Save dialog box. I navigate to the folder where the file will reside, single click on a file name that uses the same naming convention then change a single character or maybe two, then save. This time...
  19. T

    Almost sorry I upgraded to Excel 2010.

    Welcome to my rant thread. I have found Excel 2010 to be absolutely maddening from time to time. It usually has to do with something like not being able to find certain features in the new setup or the like. The most recent issue comes from the use of charts. I use the OFFSET function to...
  20. T

    Data Table not quite what I need...

    Nick: Thanks very much. I read your code... that was very clever on the counting through the data column, and using OFFSET. Thanks again! Tom
Back
Top Bottom