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?
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...
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!
Set MyPlage = Range("NamesList")...
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...
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.
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.
Selection.Find.Font.Color = wdColorRed
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...
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)...
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...
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
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.
Dim o As Variant
For Each o In Selection
o.Font.Size = 20
Thanks a lot!
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
The aim is...
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).
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...
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...
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