Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: [Solved] Concatenate and bold

  1. #1
    Join Date
    10th September 2003
    Location
    Dayton, OH
    Posts
    39
    I have the following forumula in a cell: "=CONCATENATE(B154," - ",VLOOKUP(B154,LabCat04,2,FALSE), " Actual")". I would like to put the word "Acutal" in bold, but can't figure out how to do it. When I select the word, the "bold" icon is greyed out.

    Is it possible to do this?

    TIA...MJ

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th February 2003
    Location
    Near the Land of OZ
    Posts
    1,591
    You could do this using Conditional Formatting.

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3.28.2008)

  3. #3
    Join Date
    1st February 2003
    Location
    Memphis, TN
    Posts
    891
    You can't bold the text using a formula, but you can use Conditional Formatting.

    Select the cell you want to format then click on Format>Conditiona Format

    Select "Cell Value Is" then "Equal To" Then type in ="Actual" in the last box, then click on the format button to set the text to bold if it meets the criteria.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Printer Prints Non-Bold Font In Bold
    By gdrew in forum EXCEL HELP
    Replies: 3
    Last Post: May 6th, 2008, 10:58
  2. Replies: 1
    Last Post: February 27th, 2004, 12:05
  3. [Solved] Formulas: If or Concatenate???
    By Judie12345 in forum EXCEL HELP
    Replies: 18
    Last Post: October 26th, 2003, 02:46
  4. [Solved] VBA: Bold or Color to text in MsgBox?
    By pt5014 in forum EXCEL HELP
    Replies: 4
    Last Post: August 22nd, 2003, 06:49
  5. concatenate [SOLVED]
    By hutchval in forum EXCEL HELP
    Replies: 2
    Last Post: April 25th, 2003, 13:28

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno