Excel Vba Bold Text In String

Special codes like page numbers and dates can be found in the constant definition section. Learn how to build 10 Excel VBA applications from scratch. Your table does inspire me to analyze and exploit more about this mystic-beast AutoFilter feature in Excel. TypeText Text:="This is the sentence I am inserting. But what if you wanted to extract only the bold portion of it? You can use a UDF (User Defined Function) to do just that. Tuesday, January 4, 2011 7:13 PM. They return a new string with the changes the function made. Here are the steps: Right-click on the worksheet tab and select View Code (or use the keyboard shortcut ALT + F11). The following example removes bold formatting in the active document. How to write VBA code (Macros) in Excel? To write VBA code in Excel open up the VBA Editor (ALT + F11). gsnu201011. Sure to be a hit. Excel 2016 - Merge cell and Format part of text with VBA. Bold = True Support and feedback. As a result, the current format I have on my Excel is something only I can use, as others are not able to understand the complexity of my Excel system. The VBA program opens an already existing word file stored on a hard drive and writes text into the file and makes the text bold etc. Press ENTER. It can be used as a VBA function (VBA) in Excel. is that available to bold or color a text in MsgBox via VBA as shown i insert the WD then select the start date "23-Dec 2014" and the Msgbox popped up the expected end date at the new year can i bold this end date with font size 18 and color it with red. Is it possible to format a string in VBA, so that when it appears in a report it is bold or italic eg 10:00 AM - 13:00 - this line should be bold Lunch Break - this line normal text I nned to do this as I am setting up a cross tab report and I would like control over the text in a text box, or a label if that is easier. In Excel, to bold cells are frequently used, but sometimes, you may want to bold parts of a text string in a single cell to outstand some characters as below screenshot shown. Scenario: We have an excel based reporting template. Insert however many text boxes you need to create the concatenated string. I'm trying to create a VBA module that will update data. I've tried using the Search feature of this forum but can't seem to find an answer. Now your selected picture will always be placed where Column A1 starts from left and Row 1 starts from top. Solver is a powerful analysis tool, bundled with Excel and used for optimization and simulation of business and engineering models. Read-only String. It covers topics in the most used Excel objects and collections. VBA – Drawing objects with VBA in Excel. Press ENTER. In the code below we are trying to create multiple text boxes on a PowerPoint slide using VBA code. VBA-Excel: Format already written text in a word document – Format All Content by SJ · Published July 3, 2013 · Updated January 30, 2015 To Format already written text in a word document – Format All Content Microsoft Word Document using Microsoft Excel, you need to follow the steps below:. #5: Set font bold VBA code to set font bold. The Workbook object is a member of the Workbooks collection and contains all the Workbook objects currently open in Microsoft Excel. Once a week I receive an Excel file with all the usual formatting managers like; merged cells, highlighted rows, bold characters etc. If you are confident that most of the recipients of your mail would view your mail the way it was sent the best method would be to create a Word file that you can load into a string, all formatting included. Click the Style drop-down list. It can be used as a VBA function (VBA) in Excel. Special codes like page numbers and dates can be found in the constant definition section. Please find the below code it will show you how to clear ActiveX Text Box control. Code will highlight and bold user defined text strings within cell text strings. How do you bold a portion of text entered into an unbound text box. Specify colors with VBA's RGB function. Apart from changing the color of the cell, we can change the cell content into Bold text or Italic text. VBA has a lot of commands and functions to play with. In summary, rather than check if AutoFilters are already applied to a specified Worksheet with an IF Statement, then, if they were on and in use (filtered down) we would turn them off and apply to the needed range. Ensure the Table/Range does not include the header(VBA will think list is unsorted). This is where the TEXT function is invaluable, because it allows you to force Excel to format the values the way you want by using a format code, like "MM/DD/YY" for date format. Font 'To get the content in a cell bold '(namely, cell A1 in the sample code below) 'and to set its font name, size, and color With Range("A1"). For example, you have the following text in cells. What Excel really needs is a CONTAINS function, so we don't have to do these mental acrobats. Do you want the VBA code to concatenate the strings for you or are you using a formula to do this? how are the cells concatenated? Cell 1 Cell 2 123 Mouse does the string get concatenated like 123Mouse or Mouse123?. But, have you ever tried to bold only the specific text in cells not the whole cell as below screenshot shown: Bold all specific words in a range of cells with VBA code. They are easy to use and remember, and you will use them often. Microsoft Store. Sub Tag_Bold() Dim oWS As Worksheet. Jeff has shown you how to make portions of your text Bold (i. Number of text boxes which can be created are dynamic. Substitutes new text for old text in a text string. Email with a BOLD line of text. Underline = wdUnderlineNone. I have an Excel file that generates an Outlook email. Change colour to some words in a text string -vba Word 2003: Aar=txtAar. Characters property. The asterisk may be used as the start/stop character with fonts; however, this may cause problems in some applications such as MS Word, because they may treat text surrounded with asterisks as bold text. The following examples will show you how to change the font color in Excel using VBA. Re: VBA Bold Specific Text In String Hi @Sixthsense, thank you for taking the time to reply to my post. For more information about creating drop down lists in Excel please see Excel VBA Drop Down Lists. It returns a specified number of characters from the end of text string. VBA Replace is similar to the Excel SUBSTITUTE function; both can be used to replace a portion of a string with another. There is some text in the body of the email that I would like to underline. 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. I am merging two cells in Excel 2016. See the TrimALL macro for a more robust version with additional explanations and code you would actually want to use. It would also underline the "No Fruits for you" text. Excel Text function falls under the category of String Formulas. It can be used as a VBA function (VBA) in Excel. How do you underline or make bold text sent from vba to email Posted 14 November 2012 - 07:28 AM This is my code, I want to "Health & Safety issues" line to be underlined or made Bold. In a normal text string, we may format part of the text to highlight a specific information. The object reference for Excel 2010 explains how to do this for an entire Range but not how to reference a word contained in a range. Conversion of Font color in Excel to a hex string for HTML (via VBA code) (#hexconvxl) The following code was used in XL2HTMLx conversion of an Excel sheet to HTML. VBA is used for automation operations in applications such as Microsoft Excel and also expands it's capabilities. The following does the same as the previous code, however it uses the Space() function: Sidenote: This works in VBA, however it doesn’t work in a spreadsheet formula. The VBA InStr function is used to find the position of the first space. The following two points are very important when dealing with VBA string functions. all push the subsequent text to the next row instead of adding a line break within the cell. Create a copy of the string, before you use this technique. expression A variable that represents a Font object. #ffffff hex color red value is 255, green value is 255 and the blue value of its RGB is 255. The user can select or deselect it. Select all text in the text box on each line 4. Last edited by jmsrickland; Aug 1st, 2013 at 05:03 PM. Tag: excel,vba,excel-vba,outlook,format. Identify and select all bold cells with Find command. Email with a BOLD line of text. How to write Excel VBA macro to format differently cell text in 2 lines and do this for relative text length at each line in the cell (there can be from 5 to 100 characters per cell line). However, when merging the cells the entire text is Normal. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. (the element was used to define underlined text). In this post we're going to explore how to find and replace multiple text strings from within another string. Do you want the VBA code to concatenate the strings for you or are you using a formula to do this? how are the cells concatenated? Cell 1 Cell 2 123 Mouse does the string get concatenated like 123Mouse or Mouse123?. Press ENTER. How to Use Conditional Formatting in Excel VBA? Below are the different examples to use Conditional Formatting Function in Excel by using VBA code. Value) If rCell. SQL Server – Deleting Dupes with no Unique Key. Counting Cells with Text Colors. In Excel, to bold cells are frequently used, but sometimes, you may want to bold parts of a text string in a single cell to outstand some characters as below screenshot shown. Touch base on several of the popular controls available in UserForms and we will also go over some options in the Properties menu and learned how to bring it all together. text) part to be formatted in Bold. Using these functions together is how I primarily handle working with strings in Excel VBA. If you look at the title of this article, it almost sums up what Microsoft Excel is. Is anyone please help me, How to Bold or color text on auto email body from Excel VBA? This is an urgent request. TEXTJOIN combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. resultTextBox. See lookup_value section above; If searching for a number stored as text use a string data type in the lookup_value. The following GIF illustrates the results of executing the macro example. Video of the Day. Excel uses a color palette consisting of 56 colors. This VBA code allows you to automate adding specific text (single or multiple lines) to your Word document header area. In some cases the substring you want to find is dependent on the placement of a certain character or another substring within your text. The font of the active cell is changed to BOLD. It can be used as a VBA function (VBA) in Excel. The Characters object, which can be used to set the font style for specific characters in a cell that contains a text string, will not recognize text within a formula. Tag: excel,vba,excel-vba,outlook,format. Click Replace All and you should see all the targeted words go bold. Word macros - page 3 Create a bar chart based on the content of a dropdown form field. How to Extract Nth Word from Text String Using VBA in Microsoft Excel. Changes in em size, bold tags, italic tags, and underline tags are all removed and the text is just rendered plain. I want to know if it is possible do it with formula in array not only for a cell. CODE ("A") would return 65. The code will add some txt to the body of the email. Excel allows you to define names that. The behavious of CHR function in VBA is analogous to CHAR function in MS Excel. In this tutorial, I will explain the usage of InStr function in Excel VBA and see some practical examples where it can be used. The root script you can find if you fill an excel cell whith a string, mark a text snippet in bold while runnig the macro recorder. Worksheets("Sheet1"). It returns 0 if the text is not found. Excel VBA InStr Function. I can format it to currency, but how do I set the currency value to bold text? Below is a sample of what I have. VBA is the acronym for Visual Basic for Applications. I think VBA has the possibillity's but i'm just not that familiar with VBA. Finally, the fourth and last Run object contains 'italic' in an italic style. In Word, you can make your text bold in three ways: use the Bold button on the Mini toolbar, use the Bold button on the Home tab, or use the keyboard shortcut. Chapter 1: Visual Basic Editor (VBE) in Excel. Excel 2016 - Merge cell and Format part of text with VBA. Set oWS = ActiveSheet. You must use VBA to actually test the defined conditions. Now we want to know what row or what column the currently active cell is in. If the user selects "Yes" the text in the cell under the drop down list will become italic. For cell A1, we set the font name to 'Times New Roman' and set bold to true, so our text appears in bold Times New Roman. Is it possible to format a string in VBA, so that when it appears in a report it is bold or italic eg 10:00 AM - 13:00 - this line should be bold Lunch Break - this line normal text I nned to do this as I am setting up a cross tab report and I would like control over the text in a text box, or a label if that is easier. - Men's Shoe Men's Reebok Crossfit 8. How the Excel VBA InputBox Works. VBA Replace is similar to the Excel SUBSTITUTE function; both can be used to replace a portion of a string with another. Will this text be < b > bold or < i > italic and wanted to change it into this: This is a test. I wrote above. Richtextbox in vba. Characters([Start], [Length]) Synopsis Returns a Characters object representing all the characters in a text cell or a specified string within the text. AutoFilter Criteria in Excel VBA Ok, last page we looked at how we can set AutoFilters up within an Excel Workbook. Is there an easy VBA. The word "All" is the 18th word in this line: "The figures shown above are a % of a persons time within a given month and include All work activities allocated to this person in Clarity inc. Email with a BOLD line of text. Do you want the VBA code to concatenate the strings for you or are you using a formula to do this? how are the cells concatenated? Cell 1 Cell 2 123 Mouse does the string get concatenated like 123Mouse or Mouse123?. Insert however many text boxes you need to create the concatenated string. My purpose is only to touch on some important and quick methods to utilise this for our benefit. Otherwise it returns the character position where the text is found. That will give you more control over the fonts in whatever text boxes you use. Send Mail With Link to a Workbook, From MS Outlook using Excel. It also shows you how to bold just one line of text inside the header area. Need VBA macros using for highlight duplicate paragraphs or text strings of specific bold fonts within a document. For simplicity, the user changes will be bold. that VBA is the. There is some text in the body of the email that I would like to underline. Italic - Also working the same way as a word processor, italics displays the text at a slight angle. Is anyone please help me, How to Bold or color text on auto email body from Excel VBA? This is an urgent request. A string is basically any kind of saved text. NET Private Sub ExcelDocViewer(ByVal fileName As String) Try System. Visual Basic for Applications. If you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text. Orientation of Cell Through Excel VBA. Hello, I have created a Macro enabled template with User form that automatically opens when the document is opened. AddTextbox(msoTextOrientationHorizontal, 100, 100, 200, 50) ' add shape. I used the tags but that doesn't work. Du kannst Beiträge in dieses Forum schreiben. The FORMAT function is a built-in function in Excel that is categorized as a String/Text Function. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. If you are confident that most of the recipients of your mail would view your mail the way it was sent the best method would be to create a Word file that you can load into a string, all formatting included. Click the Style drop-down list. Is there a way to do it?. Learn how to build 10 Excel VBA applications from scratch. For example, the ISTEXT function will check if a cell contains text and return TRUE if it does and FALSE if it does not. For this, Follow the below steps to use VBA Active Cell in Excel. VP2617 replace or other non-code options to make the text string bold AFTER PASTING IT AS VALUES. It can be even more powerful if used in conjunction with VBA, to automate solving of multiple models which use different input parameters and constraints. " I would like the dollar amount to show in bold. The Text property is most often used for a range of one cell. Excel is powerful. T function. The VBA program opens an already existing word file stored on a hard drive and writes text into the file and makes the text bold etc. Macro can easily be modified to perform as a function subroutine. Excel VBA Bold SubTotal or Total values October 08, 2014 This piece of VBA code below, will search for the word "Total" and set the font of the next column to bold. This is the best I could come up with before heading to class. Download Example File Excel has a great built in function called SUBSTITUTE which allows you to find one bit of text within another text string and substitute it for another bit of text. I used the tags but that doesn't work. Setting up a variable to hold text is quite straightforward. com show printable version !!! hide the show to save images bellow, right click on shown image then save as. In Word, you can make your text bold in three ways: use the Bold button on the Mini toolbar, use the Bold button on the Home tab, or use the keyboard shortcut. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. For simplicity, the user changes will be bold. Du kannst deine Beiträge in diesem Forum nicht löschen. Formatting a Text String in VBA. This page lists over 500 colours by colour name, Hex value, RGB value and Microsoft Access code number. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z , uppercase letters A to Z , basic punctuation symbols, control codes. I can do it. Using these functions together is how I primarily handle working with strings in Excel VBA. In this example there is text in row 2. Formatting text in Excel in C# Spire. Microsoft Access and Excel with Visual Basic (VBA) run seven simple queries and to render the results to some text boxes on an Access form. The text in cells that match with the search criteria will be in red color. I want to format multiple cells at once, but with some parts of the text in the cell to be change, some to remain the same. Select the text that you want to make bold, and do one of the following: Move your pointer to the Mini toolbar above your selection and click Bold. Public Sub MakePieChart(ByVal title As String, ByVal _ category_title As String, category_values() As String, _ ByVal value_title As String, values() As Single) Dim work_book As Workbook Dim last_sheet As Worksheet Dim new_sheet As Worksheet Dim r As Integer Dim min_r As Integer Dim new_chart As Chart ' Make a new worksheet. It can be used as a VBA function (VBA) in Excel. ShapeRange(1). Format cell text under VBA control Formats individual words (actually any embedded text string) with a cell?s text. ( same code below but need add specific bold fonts) for more clearly just (Need highlight duplicate paragraphs or text strings of bold size only) Skills: VB. Based on this information you have to feed a VBA-Script. Private Declare Function ShellExecute Lib "shell32. LineStyle = xlContinuous. The past two weeks these lengthy entries are showing up as pound signs (#####) when I click off the cell. One of the core features of VBA in Excel is to assign values to cells after calculations. It can be used as a VBA function (VBA) in Excel. PS: When posting code, please use the code tags. excel vba: make part of string bold. Add ActiveX Text Box With VBA. Count occurances of a pattern of characters (numbers or text) in a range Counts the number of times a user specified string of numbers or text exists in a range of cells VBA Express : Excel - Count occurances of a pattern of characters (numbers or text) in a range. The text in cells that match with the search criteria will be in red color. In VBA Format Date function you have the option to either define your own format or use some of the MS Excel predefined format. How to extract text after the second or nth specific character (space or comma) scott @ December 29, 2017 Excel Examples In the previous post, we talked that how to extract text after the first occurrence of the comma character in excel. Formatting Range: Font: 9. You can see these colors if you display the Patterns tab of the Format Cells dialog box. Your code is evidently created via the macro recorder. Replace the "Sheet1" text with the cell to which you want to assign a value. In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it! I highly recommend that you check this guide out before asking me or anyone else in the comments section to solve your specific problem. But, for now, this is what we have to work. If you want to insert certain information in the header / footer of the worksheet like the file name / file path or the current date or page number, you can do so using the below code. etc I import this file into Access to run some VBA, loosing all the formatting in the process. Application. Sometime it is very helpful. Bold = True Support and feedback. Re: Make a string bold in VBA Stephen, Thank you for your reply, the first string contains more words (sometimes 3, sometimes more) so the second string is not always on the same place when counting the spaces but it's always the same code/letters. the code reads something like this. 49999999 Range("C1"). I have the following code that selects data from an Excel Cell & replaces a specific piece of text in my Word document (for purposes of this question, the Excel Cell has been replaced by a plain text string). In VBA, the range is also called as the property of an individual cell or a group of cells in any row or a column. Ask Question (a string) in lines of text splitVals = Split(ActiveCell. Formatting Numeric Data to “Millions” in Excel by Liying Cui, Statistical Modeling Analyst, Southern New Hampshire University When we report large numbers (especially related to financials), the default number formatting in Excel does not show up nicely in tables or charts, making it hard to read in a glance. VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft that is now predominantly used with Microsoft Office applications such as MS-Excel, MS-Word, and MS-Access. “ little-endian ” (most PCs, 4321 order). The text in cells that match with the search criteria will be in red color. Excel Formula Training. VBA Code to set the location of the inserted Picture. , but it is quite complicated and time consuming (lots of class modules and messy stuff). vba code in PowerPoint to find text and format Bold = True Excel Function to reduce Cell Formats. Identify and select all bold cells with Kutools for Excel. If you had specified bold for the replacement font when doing that, you'd have the code for specifying a bold replacement font. Create a copy of the string, before you use this technique. Controlling Word from Excel using VBA Posted on June 22, 2017 April 27, 2019 by Excel Off The Grid This post is the second in a series about controlling other applications from Excel using VBA. Excel And Word Applications How to make bold part of a label? Bold text in MsgBox. T function. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format. SQL Server – Deleting Dupes with no Unique Key. Please note that the string positions of the text to be bolded will be variable based on the variable lengths of the pieces I am bringing in. This step is important. Please feel free to contact with questions, feedback and corrections. The range is particularly a data set in excel. Use : To add a new text-box using vba Sub add_textbox_VBA() Dim shp As Shape Set shp = ActiveSheet. Gomez In this VBA Tutorial, you learn how to clear cells (including clearing cells totally, their format but not their contents, their contents but not their format, and other similar combinations) with macros. Print "The. ) Get the Free eBook. And this post will guide you how to extract text after the first comma or space character in a text string. Bold = False. Excel VBA ASC Function returns the ASCII value of the first character in a text. Worksheets("Sheet1"). Method 3 – Filter Bold Cells using VBA. Make text in first column bold Sub RigidFormattingProcedure() ActiveSheet. Below we will look at a program in Excel VBA that converts text to proper case. One of the core features of VBA in Excel is to assign values to cells after calculations. 05 cm This is what I have: Sub use() Dim oSl As Slide Dim osh As Shape For Each oSl In ActivePresentati. The aim of this procedure is to create a visual indication, by means of a bar chart, the value of a dropdown form field as in the animated illustration below. Lets imagine that the first paragraph in a document contains both bold and not bold text. Please note that this only works with hard-coded text and not with Excel formula outputs. Download Example File Excel has a great built in function called SUBSTITUTE which allows you to find one bit of text within another text string and substitute it for another bit of text. So two formattings in one cell is possible - but when merging? Additional info:. How to write Excel VBA macro to format differently cell text in 2 lines and do this for relative text length at each line in the cell (there can be from 5 to 100 characters per cell line). Video of the Day. I'm passing in a string which includes all of the tags, and I am getting a normal text string back out. How do I bold all instances of a string using Word VBA I want bold all instances of a string of characters (usually a word) in Word 2010 VBA? I presume that I would use the Range object but I don't know how to use that to bold all relevant instances of a string. expression. The aim of this procedure is to create a visual indication, by means of a bar chart, the value of a dropdown form field as in the animated illustration below. For experts, discover useful tips and tricks to help keep you going. I want to format multiple cells at once, but with some parts of the text in the cell to be change, some to remain the same. It returns a specified number of characters from the end of text string. NET? What is the problem with my excel VBA scrapping code. That's not really relevant to the question but the ultimate idea is the I copy text from a cell, remove the Excel formatting by converting it to text (i. We'll look at 3 basic functions and see how they work. As a result, the current format I have on my Excel is something only I can use, as others are not able to understand the complexity of my Excel system. Acceptable values are Regular, Italic, Bold, and Bold Italic. I am in process of creating a macro that will save the current workbook, create a new outlook message and attach the file to the message. Code will highlight and bold user defined text strings within cell text strings. How to do this is what we will learn in this example. What This VBA Code Does. If that is correct, you cannot do it directly in A1 because you cannot bold text that is the result of a formula. The code below will display an open file dialog and ask the user to select the path of the file to open. Arrange the text boxes next to each other, format them as No Line and format the text the way you want, e. Visual Basic for Applications. The SPLIT function is a built-in function in Excel that is categorized as a String/Text Function. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format. I to have problems with the VBA code for bold. It is a read-write property so your VBA code can change the number format of a cell. Font 'To get the content in a cell bold '(namely, cell A1 in the sample code below) 'and to set its font name, size, and color With Range("A1"). Worksheets("Sheet1"). For example, typically the text for a chart title is formatted using the default font, normally Arial, and bold with a font size of 12 point. This parameter is an optional parameter. The word "All" is the 18th word in this line: "The figures shown above are a % of a persons time within a given month and include All work activities allocated to this person in Clarity inc. Change colour to some words in a text string -vba Word 2003 Showing 1-11 of 11 messages. In simple words, MID Function is used to extract a small part of the string from the input string or return a required number of characters from text or. TBAddressEmail. vba code in PowerPoint to find text and format Bold = True Excel Function to reduce Cell Formats. We will talk about how to get the editor set up within Excel using VBA. Rich Text Format (RTF) is quite popular with Outlook users, however. 9 digit numbers can be formatted using Excel's cell formatting as a 5+4 Zip, which will provide the hyphen in the Excel display whilst retaining the number as the raw data. Dim FirstUL. For example, cell A1 to cell B3 is a range of cells if they contain a value of some sorts or they are empty. The SPLIT function is a built-in function in Excel that is categorized as a String/Text Function. T function. I have a list of text in Excel that I need to make bold; I also need to match entire cell contents for some text but not all. NumberFormat = "0. In VBA, the range is also called as the property of an individual cell or a group of cells in any row or a column. Replace string "without" search format and replace format text files in. This code searches placeholders and textboxes in the presentation for BOLD text and un-bolds it Sub unbold() Dim osld As Slide Dim oshp As Shape Dim oTemp As TextRange Dim i As Integer For Each osld In ActivePresentation. The VBA provides a (limited) list of colors such as vbBlack, vbWhite, vbRed, vbGreen, and vbBlue. It can be used as a VBA function (VBA) in Excel. The range is particularly a data set in excel. Despite the information and tips out the book, I still can’t solve a problem. the code reads something like this. You can also use a filter to find text. Excel VBA InStr Function - Introduction. In reality, a color in Microsoft Windows is represented as a color between 0 and 16,581,375. Search Formatted Text using Excel VBA / Extract Boldfaced Range using Excel VBA / Excel VBA Tag Bold Text. I want to know if it is possible do it with formula in array not only for a cell.