font

Hello, I need to solve for several cells to equal the same value based on changing a certain set of values. I have tried to use goal seek to do each one individually but I can't get it to work to solve for the whole group. Below is the data set that starts with P7 in cell B2 and DWC AR Billed...

I have a specialist font for garment care symbols (Medium iron, do no wash, dry clean only, etc) which I need to show in a drop down. The font I have installed shows the actual symbols in the cell but when the drop down is clicked it shows the alphanumeric characters (t, f, x ,!, etc). Is...

I have multiple Word documents each which contain multiple tables. I need to extract a certain one of these tables and input it into Word. I have a working VBA code that can accomplish this, however, it has a few limitations. The tables contain a few unique characters (|,°,±, etc) along with...

Hi I have set excel so all new spreadsheets open with same font and size. Where I need help is when I insert a new column into other peoples spreadsheets the font changes and the size increases. I have a spreadsheet with a MACRO inserting a new column and I then have to spend time resizing and...

I have a spreadsheet that is updated daily with about 1000 rows. I use different color fonts to breakout the dates through out the month. Each day some new rows of data are added and previous rows are updated. When the previous rows are updated they font color is automatic (black) yet the...

Hello I need a script that will set font color to match that of the cell background color. My aim is to hide the texts in the cells. I have groups of rows with different background colors. The data range is A20:O68 Thanks in advance

I there anyway of changing the any aspect of a listbox items font? I deally I want the font to be green or at the very least someway of making it stand out from everything else in the list box. TIA

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Columns L:N, I got numbers fills for the character 1, X & 2, my query is to fill colours in the columns C:I as per numbers of character, for example... </SPAN></SPAN> M6="X"=1 fill C6=1"X" with green fill and white font.</SPAN></SPAN> M7="X"=2...

Hi all, I´m looking for a code that changes in all the workbook, all the text that is in red colored (red font), into black (black font). Would it be possible? Thanks in advance!

Hi I have a sheet with a column of list of words in different languages I want to get only Arabic words and put them in different row For example: input <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning...

I have a font which has graphic symbols that I what to use in Excel. The font works perfectly in Word, but in Excel it displays the font letter instead of the symbol that is assigned to that letter in the font file. How can I get Excel to display the symbol that is assigned to that letter?

Hi, I have a Range of Data that has a normal Font Color of Black, however there is a Conditional Format in place to Change the Font to Red if that Value is not in a specific list. This all works fine but I want to be able to check if any of the values are in Red Text before a macro runs and if...

I created a document, Job Card, for our technicians to fill in after completion of work. There is plenty formulas in there as well as certain size constraints for printing purposes. Therefore I protected the sheet with a password. Pretty straight forward. Some of the technicians want to be...

We use Excel to fill out some preprinted government forms on a shared computer. Someone changed the font resulting in legal issues when the next document was printed out. How do I lock the font so data entered always uses a specific font? I can see how to do it in Word, but we have to use Excel...

Hi all I would like to enter a value in a cell and have the 2 cells above and the 2 cells below all merge and increase the font size to 24 in bold. Example: A value is entered in A3. A1:A5 is merged. Font size increases to 24 in bold. Possible? Thank you! Russ

I am making a spreadsheet that is a fortnightly timesheet. It has an active x textbox for each day in the fortnight. I want to be able to change the font size of some lines within the text boxes. Is there a simple way to do this like a button that increases the font size by 1 level with the...

In a cell you have in black font 'something', and then another word in a red font. I can use conditional formatting to make the cell font color, let's say, purple, but it only changes the black font word. Any ideas?

Someone went through a workbook and changed the font within cells (NOT the whole cell) to a different color. I need to capture all the text with a different font color (yellow). I can use this if i step through every character in every cell: If cel.Characters(y, 1).Font.ColorIndex = 6 then is...

Hi I have a table and in column c I have cells which have black font and cells with a blue font. When the toggle button is pressed I want the cells which are black to remain black font and the cells which are blue to match their interior colour, in other words, they seem to disappear. The...

Hi, I have shapes that have text and I need to change the text font color of any "please change color to blue - example" if it's found in shapes. How can I do that in a macro?