font

Hello, This code is not returning more than the number of sheets in a book. Each sheet has plenty of Red font cells. Not conditional format. Dim Sh As Worksheet i = 0 For Each Sh In ThisWorkbook.Worksheets With Sh.UsedRange With Application.FindFormat.Font .Subscript =...

Hello, I am a total VBA novice and I really need some help with this problem. I have 10 excel files that contain 5 worksheets in each of them. The values of 3rd worksheet (of all excel files) of Cell C24 change regularly to Red or Green font values. I'd like to change the red color values...

The font size in one column of my data is different from the others. How can I keep the correct sizes when the data is concatenated? Thanks!

Good morning to all, I am trying to customize the ribbon of excel 2019. I would like to create a dailogboxlauncher to open the "Fill Box" of "Format Cells" as I have already done for the "Font Box" in an another group : <dialogBoxLauncher> <button idMso = "FormatCellsFontDialog" /> </...

Hello,</SPAN></SPAN> Not sure can be done "0's" font colour red</SPAN></SPAN> As per example below Book1ABCD123451 | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | &lsqb;COLOR=#ff0000&rsqb;0&lsqb;/COLOR&rsqb; | 1 |...

Hi all, I'm trying to change the "automatic" font colour to my company standard colour in Excel 2016. It seems it used to be possible to set this colour in Windows "Personalise" in previous versions of Windows, but Windows 10 works differently and doesn't allow this any more. VBA seems to think...

When I use the Format Painter to copy the formatting of a cell with NO hyperlink to a cell WITH a hyperlink I lose the default (and desired) blue hyperlink font color. The link is still there, but the font color changes to the source font color. These are hyperlinks that were added by...

This is a re-post of a question that I initially posted in October that I wasn't able to get a solution on: I have a spreadsheet that has multiple tabs. Each week I run a report and place it on the "CURRENT" tab and manually change the formatting in some of the cells in col b based on the name...

hi i have 3 columns in a spreadsheet i want to extract the blanks from A (or B) that dont match the exact sku in B (or A) is there a quick find/sort way to do this? thanks in advance for your help!!! joe =) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font...

I'm expecting this to be difficult, though it's just a very simple thing :) I have a cell, let's call it A1 that a value it put in. There are then other cells which are simply mirror copies of this. Let's say, just as examples: B2, D5, E6 and F9 These other cells, simply have =A1 in...

I have 42 list boxes. When the file is opened on a different PC and then i reopen it on mine the font shrinks. Is there a way to loop through all 42 boxes when the file is opened and set the all to font size 24?

Hi everyone, I need a macro to change the font of entire rows of data for two conditions. (1) If column C (age of column B) is greater than 30 days, but less than 61 days, the font should be BOLD and BLACK. (2) If Column C is greater than 60 days, the font should be BOLD AND RED. I'm...

Hello, Is there a way to alter this code to post the font, font size, and font color to the destination sheets? What I mean is to maintain the individual cells from the source sheets. Thank you very much for your help, XJ <code>Sub AddEventsToSheets() Call ClearCells Dim ws As...

OK I have not been able to get this working. What I am trying to do is to when the value in B8 is changed the format of cell C6 on sheet Diagram has the font, wrap and shrink to fit changed based on the length of the entry. Values greater than 16 small font and wrap text. Values less than 16...

I have a column of numbers, including blank cells and cells with different font colors. Is it possible to add only those cells which are a specified font color, e.g., add only the cells with red font color? I'm using Excel 2011 for Mac.

I have a spreadsheet that has multiple tabs. Each week I run a report and place it on the "CURRENT" tab and manually change some cells in col b based on the name listed: highlighted yellow, green font or red font. There are also cells that are highlighted yellow and the font can be either...

Hello, I've tried debugging this problem in every which way possible. I can't seem to fix it, it always comes back. The problem is that the font size of some of the textboxes always goes as size or two down. (Attached Screenshots) After searching everywhere on the internet, I can't find an...

Below is a Macro that deletes everything outside of the print area and changes all font to a specific grey I need to change to. Only problem is some sheets have white font in them that I need to remain white. Does anyone know how to alter the last part of this Macro to be something such as: If...

Hey team, my VBA knowledge is extremely little, so hoping I could get some help here! I currently have a worksheet that automatically generates "Total" in a cell when a certain condition is met through an IF function. I now want to increase the row height, font and font size in the row that...

Hi All, I've found a macro online that I am using to save a fixed range to PDF, with the name generated by cells within the sheet. However when I try to run the macro it returns this: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'}p.p2 {margin...