I have been trying to put together some VBA code that will look for specific text in a range from a list of approved words that I would like to bold. I found some code on the web, and have modified a little bit, but what is happening is that I am only getting items that aren't on the list to bold instead of the items on the list to bold and no other text.
Here is the range of text that I want to be searched on Sheet1
******** ******************** ************************************************************************>Microsoft Excel - Book1.xlsm___Running: 12.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutC8=ABCD1Text 2List 33 4Something 5Test 6More Text 7Another Item 8Etc 9Another Test 10Run 11Home Sheet1 [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
And then the "List of Terms to look up" on Sheet2
******** ******************** ************************************************************************>Microsoft Excel - Book1.xlsm___Running: 12.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutA1=ABCD1Text 2List 33 4Something 5Test 6More Text 7Another Item 8Etc 9Another Test 10Testing Sheet2 [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR........................
I have a couple of active x text boxes that I am using in a user form to enter data to a sheet. I wasn't able to get the text to move to the next line, but I changed the Multiline and EnterKeyBehavior to True and now when I hit enter it is working how I want it to. But when I click ok on my user form it is putting the data where I want it but it is putting a symbol that looks like a ? with a border around it in where I am pressing enter. Is there a way to avoid having this symbol show up?
The other question I have is if it is possible for specific text to be Bold in the text box and some not? I haven't been able to figure out a solution for that.
After using the subtotal function, I need to highlight and bold the subtotal rows. There are thousand over rows and it is impossible to do it manually, does anyone has a solution to this?
i want to underline and bold the lowest value in a column.
this i thought was easy enough to do using conditional formatting.
my conditional formatting at the moment makes the cell which meet a certain figure go green and red if the figure dosent meet the target figure.
i cant do this as even if the cells dont meet the target figure i still want the lowest number underlined/bolded, and i cant seem to do this without making the colors go wrong
way to AUTOMATICALLY BOLD the first 10 Characters of a cell entry?
I can do it by manually selecting the first 10 characters and then clicking Bold but I am hoping for an automated solution? Changing the font to a different color (the first 10 characters) would work for my needs as well.
I'm working in Excel 2007. I'm wondering if, with conditional formatting, there is a way to bold the lowest value/number, in EACH ROW? I've tried highliting all 1500+ rows in my worksheet, but what happens is that it bolds ONLY the lowest number in the entire worksheet, as opposed to the lowest number in EACH row.
Is there a way to do this, outside of doing the formatting for EACH and EVERY row, individually (Which would take forever with 1500+ rows)?
I have two conditions setup in Options>View - Zero Values.", "style="background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;"");' onmouseout='GAL_hidepopup();'>formatting.htm" target="_blank">conditional formatting. The first is setup for alternate row coloring with this formula inside Conditional Formatting:
Formula is = MOD(ROW(),2)
My Second Condition is
Cell Value is between $P$10 and $Q$10. This sets the font bold and a different color. The two cell values are two dates. I want to change the cells font color and bolding as long as the value is within that date range. It works fine, but for cells that are on the row that is colored the second condition doesn't apply for some reason.
I would like to be able to compare the "standards" in Column A with the Assessment status in Column B and the Assessment period in Column C in order to generate a compact list in another workbook (ideally) or tab (if not). A list might typically contain all the standards that have been M (mastered) during a given Assessment period. I realize that filters would achieve this to a large extent but I was hoping to automatically populate another worksheet or tab.
refer to the attached workbook for reference. I am looking for a function in Sheet1, Column E that will search for the value of Sheet1, Column A within Sheet2, Column A. When a match is found, the function should look across Sheet2, Columns B - V for values of 1. When such values are found, the function should return the associated value from Sheet2, Row 2. There may be multiple values of 1, and as such, the function should separate values with a comma.
I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?
I have a sheet in which some of the cells have two strings separated by a linefeed. I have come up with a cumbersome formula which will let me check if either of the two strings is a member of a list stored on another sheet. However, it fails if there is only one string in the cell, presumably as there is no linefeed for the formula to find. How can I modify the formula to cope with this situation?
There are also on occasions, three strings in the cell, but I can't seem to access the middle string with the formula. Simplified spreadsheet attached to show the problem. This must be formula-based, as we have a no VBA policy. If you think there is better way of doing this, please let me know.
I have a range that contains text. Let's say the range is colums $F:$M. There is x rows and in each cell there is either nothing or a word, let's call it "dummy". There is just a certain amount of "dummies", such as "dummy a", "dummy b" and so on, let's assume ten different dummies. It can also happen that "dummy c" or any other dummy appears more than once in those colums.
What I want Excel to do, is looking up columns $F:$M and make a list (possibly sorted) that includes all the entries from columns $F:$M, but each one only once and no blanks. Can I do this and if, how?
I am trying to add a text list, so that the value returns the number 1 in a cell regardless of what name is entered from the list i.e. =IF(B4="Smith""Townsend""Velez""Willer",1,0)
I am currently using a pivot table to display data. At the moment, as you can see from the spreadsheet I have something that shows land use, suites and costs. how to calculate a total cost - but only counting each suite once.
I would like to do similar thing for the bottles required, this is based on information from background! I am hoping get something just like the way costs are generate, by only counting each bottle once.
I have form with a list box lstEmpName which is populated from a sheet "Records" range a1:a35. This is in the UserForm initilize sub.
When a name is selcted I want the corresponding payroll number (found in Records range B1:b35) to auto popuate the txtPayroll box. I've had a go at some code but it's not working in the Userform Initialise sub and I don't even know if this code would work.
So basically I want to add the FY 09/10 to the bottom for the entire list of vendors. On top of that, all though it's not a critical, I would like to have the FY 09/10 be a different size and boldness.
I want to write a formular to initiate an action if a particular text is not in a list For example, I have a list in column D1:D50, and I want the following to happen in say cell A1
If "apple" is not in list D1:D50, then in put "N" in cell A1, else input "Y".
I have a cell with a long list of phrases all separated by commas.
So it would appear, chicken, beef, steak, soup, fish
I want to create a rule in a cell to identify if one of those phrases comes up - so if chicken comes up then a 1 would appear.
To make it interesting is it possible to grab two words from the cell, so grab the words chicken and beef from a mass of words in one cell and bring it across.
I have these cells which contain huge amount of text and preferences and I am looking to identify these entities on if they contain these words.
Any formula to recognize and copy text from any sheet and create a list of the text items on separate sheet. Attached is a sample file I use. The text items in sheet 20 column a,b,c are items I want copied to a different sheet (list). i would like those items in the 3 columns to be copied and create a single list so I can have a count(Don't want duplicates). From there I would add another formula to give me a count.
I have a list of locations, I then clicked another cell went to Data tab and selected Data Validation, and then clicked under "Allow" the List option and for source I put the range of my locations.
So I now have a list dropdown of locations.
What I need to do is add predicitive text to this, so when the user selects L, it for example shows london. This works when u use the filter option, but I need it to work using List Dropdown, is this possible, >? maybe via VBA code.
I have a list of data (about 8K records) and I have identified those that are duplicates by changing the text colour to blue. Now, I want to remove the data that is black (and not duplicated).
I've managed to create a drop-down list with the following possibilities:
Yes No Others
When the option Others is selected, I would like the user to be able to input additional information in a new line with wrap text formt (this new line should be hidden when either Yes or No is selected).
I am trying to find a short way of creating a list using the drag down tool. Normally this isn't a problem when the numbers are at the end of the data, however they are in the middle so the drag down tool does not like it and will only copy the same data into the cells below.
Eg. the list I am creating goes as follows:
Dicso 80Gb: Cyber Records Barcodes: CR 001. ai Disco 80Gb: Cyber Records Barcodes: CR 002.ai Disco 80Gb: Cyber Records Barcodes: CR 003.ai
...and so on.
How do I create the formula to recognise that I want the number within the text to increase by 1 each time?
Need to do (preferrably as a UDF so I can call it many times and build the macro I really need) the following string testing macro. For a given column (B) - look to the field immediately to the left for a text string. This string will be searched for a list of other strings contained in Column D ( cells D1:D5). We want a case insenstive SEARCH (or find I suppose in macro terms) to return a true if the strings are found or false if it is not. Example test string in cell B1 would be:
