font

  1. Z

    Font ? =+ not returning it in script

    I am pulling into cell A52 =+j12 from cell J12 thats arial font but in A52 i have the cell to script , but its now returning it in script.
  2. B

    Arial size 8 as default. Should I use macro or is there a better way?

    I like to have all my spreadsheets as Arial size 8, many spreadsheets I receive from colleagues and clients as different sizes and font and I just change manually by highlight all and edit. Should I just use a macro and shortcut key to change this or can anyone suggest a better way?
  3. J

    Programming the VBE with VBA

    Hi. I read through Chip Pearson's Programming the VBA Editor and his examples are working for me. What I want to do is programmatically control the font in the VBE code modules without using the Font Dialog because that dialog does not exist on the Mac. After checking the Object browser, it...
  4. J

    Change font color and style

    Hello, I came across this code which changes the Font color for individual names within a Range. How can i also include the functionality to change the font Name, Style Size and Boldness for each individually? Thanks for any help! Sub Change_FontColor() Set MyPlage = Range("NamesList")...
  5. G

    Formatting Half of the Cell data in formula

    Hi, I have a formula in Cell C1 "=Text(A1,"0.00") & $B$1" I have a number in A1 and a Text in B1 While displaying this in C1, I would like to have bigger font for the number and smaller font for the text in order to accommodate within the width of cell C1. How to achieve this task? Kindly...
  6. D

    change default font color

    ok, so i redesigned a template, but what i shoul;d have done is use a new workbook because every time i type something in the template, the font color is red. is there a way to change it so that it's black?? using excel 2010.
  7. S

    Vba code to just find red font color text in powerpoint

    Dear Team, I am using the mentioned vba code to find text in font color red in powerpoint . The below mentioned code i was using to find red color font text in ms word. Sub newred() Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorRed With Selection.Find...
  8. E

    Selecting Row based on a Cell Value

    Hi all, I have data that is always changing. I need a macro that searches through column AH for the word "Black". If the word "Black" is found then that row gets selected and the font gets changed to red. I have to code for the red font, I just cant figure out how to select the specific row...
  9. TheRogue

    Font Selection Based on Variable

    I have a Toggle Button, linked to C1, which returns a TRUE/FALSE. What I want to do is change the font formatting of a <Text Range>, based upon the result in C1 If C1=FALSE, then <Text Range> displays in the default font (Arial, 10), but If C1=TRUE, the <Text Range> displays in (Times Roman, 12)...
  10. N

    VBA - Footer font colour with long date format

    Hello Mr Excel gurus, As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet. I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with...
  11. R

    Conditional formula

    I need a formula for conditional formatting that will color a font based on the condition that compares the value in H12 through S12 to the value in H13 through S13. If line 12 is of lesser value than 12, color the font red. thanks in advance
  12. S

    [VBA] manually-select ActiveX commandbuttons & change font size

    I need to manually select certain ActiveX commandbuttons on a worksheet, and then change its font size. Below is my attempted code but returns error. Sub Testing() Dim o As Variant For Each o In Selection o.Font.Size = 20 Next End Sub Thanks a lot!
  13. kelly mort

    Slightly tricky conditional formatting

    I have this code I want it to do a job for me but it's not finishing it properly. Dim eCell As Range For Each eCell In [E5:E18] eCell.Offset(eCell.Row-5, -1).Font.Color = eCell.Font.Color eCell.Offset(eCell.Row-5, -3).Font.Color = eCell.Font.Color Next eCell The aim is...
  14. S

    Complex Goal Seek or Solver Solution

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

    Special symbols/font in data validation

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

    Copying Tables from Word to Excel

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

    Insert Column with the same format + size as rest of tab

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

    Change Font Color

    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...
  19. kelly mort

    VBA code to set font color to match background color

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

    ListBox Item - Change text font

    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

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top