font

Hi all, I have a table that has multiple matching entries and i'm trying to use .find to get the right match. Here's where it get's complicated. I want it to find the first match with a specific font format. eg. Row 1 apples in font yellow 0 Row 2 Bananas in font yellow 0 Row 3 Apples in...

I'm trying to change the font color in Normal style. I have been able to change the default font and default size but not the default color.

If you receive a workbook where the document was created with an undesirable default Font/Size, what can be done to change it, other than editing the documents XML? Setting the Font/Size for headers is done under: File\Options\General... When creating new workbooks Make it a nightmare by...

Hello,</SPAN></SPAN> I got a list in the column M that has a Start row number & in the column N that has an End row number </SPAN></SPAN> I need to do font colour in the area columns C:J as per row numbers are listed in column M:N </SPAN></SPAN> For example </SPAN></SPAN> C6:J15 = font...

Looking to find a way to force sheet contents regardless of range to fit to page and make font suit page size meaning if the sheet has only 5 rows of data then blow it up to full A4 size including making the font bigger to suit and if the data is lager than one page reduce …reasons being...

Writing a simple formula but need to figure out how to include an if formula for red font and negative numbers.

ok so i know this is not the right syntax for if else, but just to make it pretty straight forward, how would i write this in VB? (the red letters are just to make the example. =if(A1 ="r", B1 font color =orange, B1 font color = black ) i tried this, please dont laugh ! ha...

Cell B2 has a numeric value= 5 Cell A2 has text with 12 characters Looking to a way to format the font for characters in 6,7,8,9,10,11,12 in cell A2 to red I can only find a way to conditionally formatting for the entire cell

Hello, I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below: C1=A1&"/"&B1 I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font...

Hey all, I'm trying to take text in one column and have it spit out a barcode in a second column. Doing some searching, I've realized this might just be a font issue. Am I right, and where can I get the font (preferably free) to install on a Mac? Is there a formula for changing fonts in a...

Hi I often end up pasting in information from various sheets and want to change it all to Calibri, so I hit control+A twice and then type in the Font box. However, when I type in Calibri, it defaults to Calibri Light, which I don’t want. Even if I exactly type “Calibri”, if I hit enter, it...

I want to do a count of unique numbers in column C 7797 7800 7428 7797 where the Font is not RED and returns a count against a user ID in Col J IR1- IR2- IR3- Any Ideas If RED Font is in issue in 2013 then ignore that

Conditional formatting as per group pattern </SPAN></SPAN> Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need conditional formatting as per groups PATTERNS</SPAN></SPAN> Group-1 pattern "1|1" interior colour RED & font colour white</SPAN></SPAN> Group-2 pattern "1|X", "1|2", "X|1", "2|1"...

Hi Everyone, Could you please help me changing of selected font color inside a cell. Selection of words/ characters is depends on the user wants to color. Ex, "John Peter" i wanted to color only "er" which is at the end "Dave Smith is a corporate trainer" color only "a corporate" Kind Regards, RN

Hi, How could I write the following excel line of code in VBA and add conditional formatting (interior and font). =IF(AND(OR(F19="1ere",F19="2me",F19="7me"),OR(M19=2,M19=6, M19=9,M19=11)),G19,"neant") I have a range of columns from (B3:AJ3) Thanks in advance for your precious help Bruno

Hello friends, hope all is well! please help me with the code here please. Trying to place a custom footer, with a certain font size, but I keep getting the font size in the footer (i.e. 1228 - Aug - 2018 18:16:07) Please help me place only the date & time in the footer. Thanks a lot in...

I am attempting to automate an Outlook email creation from within Excel. I'm using Outlook 2016 and Excel 2016. I have a spreadsheet that the end user adds rows to, and flags the row to be emailed with a Yes/No value. I want the rows of data to be in a monospaced font, such as courier or...

Hi, Is there any way that I can download a listing of all the fonts that I have and in each cell they change to that font? For example: CELL A1 - would say Arial - in the that font CELL A2 - would say Arial Narrow - in that font

Hi, I am using the following code. My problem is that when i add a hyperlink into this cell the Font Size should be 10 but its actually say 22 If i type manually in the same cell or actuall any in column D then all is well and the Font Size is 10 as it should be. Private Sub...

Hello, I have 4 columns in sheet 1, in which the first column has cells whose font color is red. I want to copy only those rows whose first column cell data has red font color to sheet 2.