searched

I'm using conditional formatting but I either get only the first cells to change or if i use the $B$2, it changes every cell regardless of the rule. Here it is: CF= =B2="Kermit" Only changes A2 - rest of spreadsheet to green and none of the other selected sales (through F500) CF=...

I'd like to be able to identify if any cell in an excel table has changed by either highlighting the whole row or the cell in question. Can't use track changes because doesn't work with excel tables. Any ideas? have searched and searched but can't find any solutions :(

For example I make something bold, and the code notices this and runs. (without change the content) I searched for it, but haven't found any information. Have a nice day!

I have searched the site and I cannot find what I am after. I have a sheet which use for authorising overtime timesheets. I have written the formulas and now I want to hide them. In excel 1997-2003 version, I could do this but I have been away from this type of work for at least a good 5...

I have tried for days now and searched many forums but to no avail....

I am trying to extract a character + number combination then turn it into a date. For example: aa23 = 1/23/2001. The difficult part is my data is sometimes presented as 11aa23y or LYAA23. The key pattern is always 2 letters followed by 2 numbers. I need to extract that, then convert it using a...

I am trying to figure out the best way to perform a VLOOKUP where as the value I am looking for is found somewhere within an array of letters/numbers/characters of a cell. For Example: One of the values in my lookup table has the numeric string "841752" The cell being searched contains the...

Ex; Cell A1 : "C184A" Cell A2 : =FINDSPC(A1,[Top/Bottom/Left/Right]) Cell A2 would be the path+filename to the file that's found. It needs to search a predefined folder (lets call it C:\test) for "*C184A*Top*" or "*C184A*Bottom*" etc... I've searched, but can't find any results that are very...

Hi, very new to this so please be gentle. Im trying to make a round robin draw for my local league. 20 players to play each other 3 times, `Ive searched the web and tried all sorts of different things to no avail, please if any help is available would much appreciate it.

Some excel wizardry required please. In cell B1 i have the follwoing data <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>https://example.ca/?utm_source=random1&utm_medium=random2&utm_campaign=random3&utm_term=random4 I am looking to extract...

Hello so I need to create a lookup cell in excel. There are multiple tabs of information but I need to be able to type in a name on the front tab and for it to look up all tabs and return a discount value for that customer I searched? Make sense , I know the cells i need to include just need the...

I have searched and searched and can't seem to find anything that answers my question. I have a master workbook that compiles files, then adds a "first" and "last" sheet. This part works great! I have multiple cells that I want to sum across all the compiled sheets. I can do this manually...

Hi there, first post. I'm knees deep in excel these days, but unfortunately not overtly talented (yet). I have the following issue: Two columns: A = one with a set of 1500 keywords B = 25000 sentences of text C = the output (which should also be the keyword) I need to search the sentences...