Search results

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...

spikepl... thanks, but.. huh???

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...

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...

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...

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...

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...

Thanks very much. I'll check it out.

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...

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...

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...

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...

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...

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

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.

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

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...

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...

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...

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