Excel Vba Change Font Color For Part Of Text

This example sets the font to bold for the range A1:A5 on Sheet1. In a previous lesson, you had code like. 1) Change the column width and row height in Excel using VBA: Do you know you can dynamically change the column width or even change the row height in Excel? Yes you can using VBA. Making the font Bold and adjusting the background color (using the Interior. In Word, go to Format | Font, set the font the way you want it, and click the Default button. Below you can find code samples for formatting Excel cells. To count the number of “red” words in column A we can use: COUNTIF(C2:C9,3) The 3 in the formula refers to the color red. You open a presentation file and find that whoever created it (one might say "committed it") has used way more fonts than your more highly developed design sense can bear. Dim R As Integer Dim G As Integer Dim B As Integer R = Val(InputBox("Please input red value")) G = Val(InputBox("Please input green value")) B = Val(InputBox("Please input blue value")) Dim. This Amp template offers lots of powerful options that can get you ahead of the competition. Can you change the colour of a text string in Excel mid string so that there are 2 colours in the cell?? Hi, I am still trying to format my Excel spreadsheet so that one part of the output is in BLACK and the other half is in BLUE font. This VBA Font Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. I would like to know how I can change the font colour of a label when a check box control is 'checked'/'ticked' in Microsoft Access 2003. Changing the default font in Excel is fast and simple and can help to make your spreadsheets more readable when they are printed. ColorIndex = 0 And Replace: Rng. If the property that you are looking for isn't described in detail here, don't be afraid to look for it in the list of properties in Excel or in Excel's own help files. Sub SelectCell() Range("A1"). expression. Once a user makes their selection from this list, I'd like to change the font color and background color within the combo box as follows: Critical = Red background / White font High = Orange background / Black font Medium = Yellow background / Black font Low = Green background / White font. For the rest of these steps I assume 8 pt superscript and 11 pt body text. The example demonstrates font color management, but the extensions to other procedure arguments are obvious. Choose a standard color theme. Welcome to the p2p. Drawing Imports Spire. Change text colour of part of text within text box on report. You are currently viewing the VB. SumIFbyColor() - Conditional Sum based on Font and/or Backgroud color of cells This article describes the formula syntax and usage of the SUMIFBYCOLOR function in Microsoft Excel. Excel provides an easy method to determine if a particular cell contains text. Navigating around Word file in VBA is the greatest challenge you will face. Referencing slides and shapes. To the best of my knowledge this is not possible in Excel 2003, the Font property is by Cell and cannot be applied to sub-strings within the value of the cell. Note that VBA presents the channels in BGR order, but it's still called "RGB". Re: vba changing the color of some of the text in a textbox. The above code has the mandatory ‘Sub’ and ‘End Sub’ part, and a line of code that selects cell A1. Select the Home tab in the toolbar at the top of the screen and click on the Font Color button in the Font group. Gridlines and Borders, Display and Printing in Excel Conditional Formatting can change fonts, font attributes, borders, shading (patterns) Font information on pages other than font. You can also adjust boldness, italics, color, size. Imports System. SpecialCells(xlCellTypeAllValidation). Our employees are our greatest asset and th. If you "select the text in one cell and change the color to red, and then tab over to the next cell," then the font SHOULD change back to black. If you find the default font size too small, or if you'd prefer a different type of font, you can change the Normal Style settings. You are currently viewing the VB. The user selects a records from a combo box, clicks VBA code to change label text colour. Click on Tools > Options > Editor Format tab. The Excel VBA ColorIndex property limits you however to 56 theme or default Excel colors and is rarely used in practice. Column(13, i), "$#,###. SketchTextStyle. They can help us complete some repeated tasks automatically. If you expand slicer styles list, you will notice an option that reads New Slicer Style. Bold = False. It has professional and intuitive characteristics, which you can see from its vast collection of elements. and underline. This can be done using formatting those characters. Note that VBA presents the channels in BGR order, but it's still called "RGB". Use : To add a new text-box using vba Sub add_textbox_VBA() Dim shp As Shape Set shp = ActiveSheet. The easiest way to set this property is to use the VBA RGB function:. I didn’t have to worry about creating my own custom event, something at which I’m not terribly strong. Then on the bottom of the page it says K[color]. HTML in Cells II Posted on February 23, 2005 March 30, 2018 by Dick Kusleika While I was working on this newsgroup post to copy formatted text from Word to Excel while preserving formatting and maintaining line breaks, I stumbled on a way to enter HTML in cells. - Forum - Excel This document, titled "Excel/VBA - A macro to change the color of a row," is available under the Creative Commons license. text, objects like images and charts, tables etc. I changed mine mainly in order to work with a specific package so that the wording is black on white. Both Microsoft Excel and Microsoft Visual Basic support colors at various levels. expression A variable that represents a Range object. To change your display in Windows 10, select Start > Settings > Ease of Access > Display. expression A variable that represents a Range object. But what if I want multiple If's? So if "Project" red, if "High" blue etc?. This article contains three sample Microsoft Visual Basic for Applications macros (Sub procedures) that you can use to change the letters in a text string to all uppercase, all lowercase, or title case (the first letter in each word is capitalized). hi · NB: this will highlight. Enter your text into the document. Volatile FontColor = CellColor. The Font property of an Excel VBA Range object is another example of that concept at work. In this article I will explain how you can change the font color of cells and ranges in Excel using VBA. Option Explicit Private Sub CommandButton1_Click() ' DYNAMICALLY ADD MULTIPLE SHAPES IN EXCEL BASED ON A CONDITION. A simple change to your Excel balance sheet can provide key cash flow information. Change the Default Font Size. How to change the font color, size, or type in Excel Updated: 10/07/2019 by Computer Hope In Microsoft Excel , a user can change the properties of text in any cell , including font type, size, color, as well as make it bold , italic , or underlined. - Click drop down arrow of Font combo box to change font name. In Excel, you can change cell font size as you want, but have you ever tried to change cell font size based on another column value as below screenshot shown? In this article, I introduce some VBA code to help you quickly change font size based on cell value in Excel. This method can accept Colorstructure object as a. If you "select the text in one cell and change the color to red, and then tab over to the next cell," then the font SHOULD change back to black. Add has the following parameters. The “Font+Fill” option allows you to change both the font and fill color of the cell with one keyboard shortcut! In the example above, Ctrl+Shift+D will change the font and fill color of the cell to light green fill with dark green font. You have at least 2 options to set a Cell background color in VBA. 12 part section >> Excel VBA and Charts. This example sets the font to bold for the range A1:A5 on Sheet1. ' Omit if the color is to be left unchanged. ColorIndex = 0 And Replace: Rng. Colors includes FONT information where color is involved. For example, if I were to change G2 to a black color and a smaller font, the label would not show these new changes (however, it would change its text if I changed the value in G2 to something else). This is just a preview, though. Best Answer: Sometimes, you need to differentiate some parts of text in an Excel cell. Here's what my project looks like before applying text styles. In this article I will explain how you can change the font color of cells and ranges in Excel using VBA. - Forum - Excel; VBA macro to color a range of cells based on value of other cell - Forum - Excel. VBA-Excel: Change Font, Color, Weight of Table Data in the Word document by SJ · August 31, 2015 To Change Font, Color, Weight of Table Data in the Word document using Microsoft Excel , you need to follow the steps below (First we will create a table and while filling the data we change the font, color and weight of data):. This style property is the type of ExcelStyle (seal) class. There are two ways to do it - select part of the substring that you wish to format and change its color. Vba highlight cell - Best answers; Changing a cell value based on the color of a - Forum - Office Software; Conditional formatting: change fontcolor based on another cell - Forum - Excel; Change color to different cells based on another cells text. Vba To Change Font Color In Cells Based On Value - Excel I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. To change the font color in a cell, select the text that you wish to change the color of. 5 part section >> An Excel Picture Viewer Project. Dim R As Integer Dim G As Integer Dim B As Integer R = Val(InputBox("Please input red value")) G = Val(InputBox("Please input green value")) B = Val(InputBox("Please input blue value")) Dim. Set Default Font in Excel 2013. In this example, cell A1 is being selected. Excel Display Changed Cells in Red Font Highlighting or changing font color manually is tedious (and it's easy to overlook a change or two that you've made. Change the text color for a cell or range of cells. VBA can not change the font color of a portion of text that is the result of a formula since VBA will see the contents of the cell as a formula and not perform a "text operation" on it. Indent Text Within Spreadsheet Cells in Excel. 5 points as shown below, and click Ok. Modifying chart properties: changes the Legend font for all charts on the active sheet. in Excel Visual Basic, in a userform, I have 1). 4 thoughts on " Change the Font Size, Color, and Style of an Excel Form Control Label " Anonymous July 18, 2012 at 1:12 pm. In the report there are 3 rich text fields which may contain the text I passed in, and if so I want to change the color of that text to red so it stands out. VBA Color Index is a function by which we can change the color of the cell or text which is located in the Home menu under the Font section. I currently have to search files that are 30,000 lines long for these key words and the only thing that I have been able to do is change the entire cell. To visually change the font used by a cell or a group of cells:. Firstdayofweek specifies the first day of the week. Alex C 2,963 views. VBA Part 23 of 25: Creating Userforms and Adding Controls. We'll look at how to change these colors in an upcoming lesson. You can change the font size of new Excel comments by changing the settings in your Control Panel. Change "Dark 2" to #000000 which is black. A font is primarily known by its name. We may want to highlight the font in red if the values are negative, in green if the values are positive. SketchTextStyle. Hello everyone, I'm trying to find text in a cell and replace it with the same text but I want the text to be bold and a different color. Formating Excel cells to text format will solve the problem of losing leading zeo values when you export data from other data sources to excel. 08 - UserForm GUI - Changing the Forecolor (Text Color) Properties Programtically - Duration: 2:33. This includes when a cell is created, updated, or deleted. Before we get into the details, it is important to remember that when you format a cell using this feature, it does not change the value present in the cell. In the screen shot below, you can see that the column and row headers are in that font, and so is the data in cells A1 and B1. Home/Excel VBA/Change Font Color in Excel VBA. Check if the superscripts are the same font size (I assume they are if the data was exported from somewhere else). Here, we will see different processes of highlighting cells that contain text using conditional formatting. Once again, however, you can record a macro for at least the formatting part of the exercise - just open the Record Macro dialog and change the font color (Alt + H + FC), fill color (Alt + H + H), and border (Alt + H + B)… or use Ctrl + 1 or ⌘ + 1 on the Mac for all of that. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category. Function GetFontColor(ByVal Target As Range) As Integer GetFontColor = Target. You are currently viewing the VB. This is one small part of our free online Excel VBA tutorial. 5 points as shown below, and click Ok. I've also provided an example on how you can get the current font color used in a cell. The big change to conditional formatting behavior in Excel 2007 PivotTables is that formatting is applied (to be more accurate, can be applied) to the entire column – the point being that as the data in the column is updated with new rows, CF extends to include the new rows. And, if you want to apply it more than one cell then you select the entire range or select the non-continues range of cells and the use the shortcut. The first part is easy, you can hover the mouse over a font to preview it or Click it to change the text to that font. Welcome to the p2p. So to change our text color in purple, we should use the following code: Sub example() 'Text color for A1: RGB(192, 32, 255) Range("A1"). Use the Interior property to return an Interior object. Start by selecting the text you want to format. 12 part section >> Excel VBA and Charts. An example using a macro can be found here: Macro to colour part of the text in cells in Excel. Select the cell(s) whose entries you want to indent. Before we get into the details, it is important to remember that when you format a cell using this feature, it does not change the value present in the cell. Color = wdColorRed. Modifying chart properties: changes the Legend font for all charts on the active sheet. VBA Programming for Excel 2010 - V4. The syntax of LEFT function is as follows: Left (text_string, length) Here 'text_string' refers to input string which is to be separated. Set rng = para. In "Find what" text box, enter a string available on the table in. If you begin actively using excel it will not be long before you need to change the width of a column to accommodate so it can accommodate a larger field. htm, formula. color comand, but how do i remove the font. You have at least 2 options to set a Cell background color in VBA. The form is used to require values, parameters and information from the user to feed the VBA procedure. For the rest of these steps I assume 8 pt superscript and 11 pt body text. Everyday, I modify a Word document that contains a lot of text in fonts and colors that I don't like. If the property that you are looking for isn't described in detail here, don't be afraid to look for it in the list of properties in Excel or in Excel's own help files. Using the IsText function will return True or False after checking the given cell. With this property you can insert a worksheet formula into a cell programmatically (that’s geek-speak for “from VBA”). Excel provides a way to ‘wrap’ the text. The SpecialCells in VBA Method is also very powerful if you want to test your data in an If Then Else decision code. When I opened an Excel file, I noticed that all of the text was in black, whereas in the old versions (Office and Windows) there were some cells with red text to indicate importance of that item. Advanced Access Export Function To Excel Spreadsheet Using VBA Multiple Access Functions Export Data To An Excel Spreadsheet. Get link; Facebook; ' This module will apply rainbow font color to all the selected cells. We employ 11,000 talented people across sites in Ireland, the UK and Poland. You can increase or decrease font size and change font name of code in VBA window by doing the following: - Open VBA window (Alt+F11) - Click Tools. Xls Namespace TextColor Friend Class Program Shared Sub Main(ByVal args() As String) Dim workbook As New Workbook() workbook. To change the text in a cell, first select it. how to change color of buttons How to change color of buttons in microsoft excel 2010 i tried the record macro thing but still i cant find the option fo. The user selects a records from a combo box, clicks VBA code to change label text colour. Set rng = para. Function FontColor(CellColor As Range) Application. Finally, click OK. Excel VBA and Text Files. To change the font face and size using the Ribbon tools, use the following procedure. Working with COMBO BOXES [Form Controls] This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. The "Font+Fill" option allows you to change both the font and fill color of the cell with one keyboard shortcut! In the example above, Ctrl+Shift+D will change the font and fill color of the cell to light green fill with dark green font. One of the most powerful features of Excel is the ability to write programs in Visual Basic for Applications that run "behind" your worksheets to turn Excel into a calculation-oriented development platform for creating special purpose spreadsheets which can function as applications in their own right. To change your display in Windows 10, select Start > Settings > Ease of Access > Display. Hi, You missed the part of creating a new text style and the using that for the new text box. When I opened an Excel file, I noticed that all of the text was in black, whereas in the old versions (Office and Windows) there were some cells with red text to indicate importance of that item. You will learn how to add a command button to a UserForm; how to change the text displayed on the button; and, how to change the name of the button. To visual change a color, you can use the Properties window. Select the part of text you want to change its font color, and click Home > Font, then choose a font color from the drop-down list. Select the HOME tab in the toolbar at the top of the screen and click on the Font Color button in the Font group. VBA code - Word - Copy highlighted contents in a Word document to an Excel Hi All, This is quiet urgent so people please try to help me I wan. Underline = wdUnderlineNone. For most controls including the VBA for Excel text box there are general properties that allow you to set the font, the color of the font, the color of the background, the type of background, the type of border and other design features. color to set the color to green, i understand i can set the color to black for the next line with a new font. A user in the Microsoft Answers forum wanted to know how to use a Word macro to apply formatting to selected text in Outlook 2010. Returns a Font object that represents the font of the specified object. Choose a standard color theme. Almost most of the Excel VBA programmers would have the requirement to change the orientation of the cell. In this post, we will showcase the steps for How to Change Text Font Color of Title Bar in Windows 10. For editing HTML, see our page on changing the font type, size, and color displayed on a web page. For more information on this topic please see Excel VBA, Getting the Color Code Using the Macro Recorder. This file contains code for filtering different data types and filter types. 8) With the chart title still selected, go to Home>Font and expand the Font section, in order to launch the Font Dialog box. Excel VBA - Change Font Color for Part of Text. I need some text in red. To change some aspect of a range's font, you must first access the range's Font object and then manipulate the properties of that object. And, if you want to apply it more than one cell then you select the entire range or select the non-continues range of cells and the use the shortcut. VBA code - Word - Copy highlighted contents in a Word document to an Excel Hi All, This is quiet urgent so people please try to help me I wan. Re: vba changing the color of some of the text in a textbox. Here, we will see different processes of highlighting cells that contain text using conditional formatting. Please help Thanks. We may want to highlight the font in red if the values are negative, in green if the values are positive. Once again, however, you can record a macro for at least the formatting part of the exercise - just open the Record Macro dialog and change the font color (Alt + H + FC), fill color (Alt + H + H), and border (Alt + H + B)… or use Ctrl + 1 or ⌘ + 1 on the Mac for all of that. To the best of my knowledge this is not possible in Excel 2003, the Font property is by Cell and cannot be applied to sub-strings within the value of the cell. Method 2: Use "Find and Replace" Feature to Change Font Color. Completely new to VBA, and have just started self-teaching myself. 31) How can I change the format function so my. I use this code for email and I want to have different font text, size and color for it. The form is used to require values, parameters and information from the user to feed the VBA procedure. Both of these evaluate one or more conditions and, depending on the result, execute specific sections of code. Here’s how: 1. Can be one of ' the standard colors from the Excel palette or ' can be one of the standard "vbColors". You can also adjust boldness, italics, color, size. I'll cover the following topics in the code samples below: OLEObjectsMicrosoft Excel, Interior, Shapes, Sheets, and Worksheet. This can either be the entire cell or only a character in the cell. Highlight text background color in Word 2010 / 2007 You can add a highlighter effect to portions of your Microsoft Word documents with a single click. There are several options for formatting your text in the Datasheet. You can make a worksheet user-friendly by applying some fonts and colors to their content. In Column B from 1st row to last row if specific word found Highlight that Entire row which Color (prefer Yellow). ‘Options’ dialog box opens up and clicks on ‘Editor Format’ tab. We may want to highlight the font in red if the values are negative, in green if the values are positive. To change your display in Windows 10, select Start > Settings > Ease of Access > Display. This can either be the entire cell or only a character in the cell. In this example, cell A1 is being selected. This VBA Font Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. In one easy click, you can tell Excel to resize your entire Column, Row, or even a select set of cells, so that the text fits inside it. Is that possible with a macro? Appreciate all your help. Microsoft Excel is a deep program rich in features and functionality. I have a worksheet I want to make edits too, but I want to be able to tell the edits apart from the original, e. You can change colors on various. Write a macro that will perform the following operations on cells: Fills 5 adjacent sheet cells with any text. Bottom line: Learn how to apply color and icon filters with VBA. The following snapshot is from the software interface, please have a check. Suppose you want to change the text World in Cell A1 to red color. When I select the partial text within a cell, sometimes Excel lets me change part of the text to a different color and sometimes it reverts back to black after I de-select the cell. Use the Font Effects page to apply special effects to the text, such as underlining, color, shadow and so on. The code works, but it really slows my worksheet down when opening. One variable type that we haven't touched upon yet. In Microsoft Word , a user can change the properties of any text including font type, size, color, as well as making it bold , italic or underlined. Also find related example to change font Color in Excel using VBA In this topic we will see how change the font color in Excel VBA. (part in bold needs to be in yellow background. If I save the cloud Excel file locally, close the Excel file and then reopen the Excel file from my Mac's drive, the secondary font color menu works correctly. txtGrossProfit. DescriptionYou use the SUMIFBYCOLOR function to sum the values in a range that meet criteria that you specify. Learn how to build 10 Excel VBA applications from scratch. Step 4: Wrapping the text to fit into your cell. - Click drop down arrow of Font combo box to change font name. Description: This macro applies a red color, font size 12, font style Verdana, and makes the font bold. Others may be able to comment if this is possible in 2007 and/or 2010. Here, we will see different processes of highlighting cells that contain text using conditional formatting. To change some aspect of a range's font, you must first access the range's Font object and then manipulate the properties of that object. Private Sub Worksheet_Change(ByVal Target As Range) Set MyPlage = Range("B13:I50") For Each Cell In MyPlage. This example sets the font to bold for the range A1:A5 on Sheet1. For over a decade we've been telling people you cannot change the font of a checkbox from the forms toolbar in Excel. As jethrow mentioned, instead of asking for each command, you would do better by trying to understand the means of translating VBA code generated by the macro recorder to AHK_L syntax. 4 thoughts on " Change the Font Size, Color, and Style of an Excel Form Control Label " Anonymous July 18, 2012 at 1:12 pm. You cannot replace the total value with a different text or something like what you have seen in the DAX way of doing it. hi · NB: this will highlight. text, objects like images and charts, tables etc. In Excel, you can change cell font size as you want, but have you ever tried to change cell font size based on another column value as below screenshot shown? In this article, I introduce some VBA code to help you quickly change font size based on cell value in Excel. What This VBA Code Does. In one easy click, you can tell Excel to resize your entire Column, Row, or even a select set of cells, so that the text fits inside it. Change the text color for a cell or range of cells. This article contains three sample Microsoft Visual Basic for Applications macros (Sub procedures) that you can use to change the letters in a text string to all uppercase, all lowercase, or title case (the first letter in each word is capitalized). Almost most of the Excel VBA programmers would have the requirement to change the orientation of the cell. Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?. If you want to apply this to a particular part of the text in a cell then you can edit the cell and select only that part of the text, after that use the shortcut key. Range(“A1”) tells VBA the address of the cell that we want to refer to. To make only the text on your screen larger, adjust the slider under Make text bigger. Change colour to some words in a text string -vba Word 2003 oRng. If you find the default font size too small, or if you'd prefer a different type of font, you can change the Normal Style settings. How to Change Font Size and Style of Text in MS Office Templates. Make vba code run as part of a standard animation sequence. Select [Insert] Text | Header and Footer |. Colors are used to paint something about a control. But if you like to change things up, play around with these settings. Reselect the cell and then click on the command button. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category. In this tutorial, you will see how to change the text color and font properties using vba. Note: you need to follow different steps to change the entire page's background color. 2 part section >> Excel VBA and User Forms. Font = "My font", so you'll change the font for everything that is using that specific style. Excel will show a preview of this color applied to the worksheet. Excel Text Functions List Functions to Remove Extra Characters. Overview on Excel VBA Named Range. How to change the font color, size, or type in Excel Updated: 10/07/2019 by Computer Hope In Microsoft Excel , a user can change the properties of text in any cell , including font type, size, color, as well as make it bold , italic , or underlined. They can help us complete some repeated tasks automatically. Value = Format(Me. This page is available when creating or modifying a presentation style or a graphics style. Please help Thanks. One variable type that we haven't touched upon yet. Then, it will merge, set the font size to 24, use the Arial font. SketchTextStyle to create the text and then doing oTextBox. SpecialCells(xlCellTypeAllValidation). Check if the superscripts are the same font size (I assume they are if the data was exported from somewhere else). 09 / Tags: COUNTIF , VBA When we have colors on our sheets data and want, for instance, to count how many "red" words we have on our sheet, that is not possible because there is no formula in Excel to check for font colors. VBA Programming for Excel 2010 - V4. I am wondering how you can change the fontcolor in the header or footer in VBA when exporting to excel. Font = "My font", so you'll change the font for everything that is using that specific style. The line below changes the fill color of the cell in row 2 to green. By default, the color is black. ColorIndex property of each cell) really helps to make the headers appear more prominent on the worksheet. These three controls enable you to change the button layout and size. This link has a decent explanation of what the some of the other settings do. We may want to highlight the font in red if the values are negative, in green if the values are positive. The Font object has many properties like the Color property and the Bold property. This is easy to change but where there is no text the color will remain black. In Excel, you can change cell font size as you want, but have you ever tried to change cell font size based on another column value as below screenshot shown? In this article, I introduce some VBA code to help you quickly change font size based on cell value in Excel. When I do a find and replace it selects all the text and changes it even though I tell it to search for specific text. ) Get the Free eBook Please feel free to subscribe to my newsletter and get exclusive VBA content that you cannot find here on the blog, as well as free access to my eBook, How to Ace the 21 Most Common Questions in VBA which is full of examples you can use in your own code. Let’s take a look at at how to use this function. This can either be the entire cell or only a character in the cell. The Font option. In Word, go to Format | Font, set the font the way you want it, and click the Default button. 31) How can I change the format function so my. However, the font color will be changed in order to make the special or important contents (for example, notices in instruction document) more obviously so that readers will pay more attention on the contents. Add headers and / or footers by switching from Normal View to Page Layout View. In Column B from 1st row to last row if specific word found Highlight that Entire row which Color (prefer Yellow). Change the text color for a cell or range of cells. Last week we discussed how to change the background color of a cell based on its value. Excel Display Changed Cells in Red Font Highlighting or changing font color manually is tedious (and it's easy to overlook a change or two that you've made. And select the format you like. If the value in a cell meets certain rules that you've set, the conditional formatting feature will change the color of the text in the cell, or the fill color, or both. 08 - UserForm GUI - Changing the Forecolor (Text Color) Properties Programtically - Duration: 2:33. Select the cell(s) whose entries you want to indent. Font The following statement sets to True the Bold property of the Font object contained in the Range object. I want to change the color of XX & YY text. I've a spreadsheet when I need to change the row color dependent on the data entered into a particular cell. I started off by recording a macro to see what the VBA looked like when I changed the row color for a task.