+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting Not Bolding?

  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    27

    Unhappy Conditional Formatting Not Bolding?

    I currently have a worksheet with conditional formatting on Cell Value. It changes background and font color perfectly, but for some reason it will not BOLD the text. Why?

    -I made a test by adding Strikethrough, and that worked fine.
    -I did Bold Italic, but only the Italic part worked.
    -Created a new spreadsheet to test conditional formatting and it worked.

    Why is this specific format is not letting me bold?

    excel.png

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Conditional Formatting Not Bolding?

    can you upload the file itself?....without company confidential stuff....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    03-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Conditional Formatting Not Bolding?

    Here is the sample file. Thanks in advance.

    PH_Summary_Sample.xlsx

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional Formatting Not Bolding?

    I just looked at the rules for CF and the bold is not selected. After I selected, the font turned bold.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional Formatting Not Bolding?

    Forgot to mention. You just can't have both Italic and Bold.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  2. [SOLVED] IF Statement For Conditional "Bolding"
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2012, 12:28 PM
  3. Replies: 11
    Last Post: 10-17-2012, 07:56 AM
  4. Cell Bolding - conditional
    By GB1384 in forum Excel General
    Replies: 3
    Last Post: 12-27-2009, 01:56 AM
  5. Bolding Row from VB6
    By Ian B in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2005, 07:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1