Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    conditional formatting of text (2000)

    Is it possible to create conditional formatting of text in a worksheet? I have to update a workbook that comes in weekly that describes issues we have from our field offices. Some of the issues need to be flagged as important and we currently do this with an asterisk. I would like to create a macro that looks at the contents of the descriptions and if they include an asterisk then turn on bolding for that row.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: conditional formatting of text (2000)

    If the text is in column D, try this. Format, Conditional Formatting, Formula Is, enter the formula below, set the Format to Bold, copy down.

    =ISNUMBER(SEARCH("~*",D1))
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formatting of text (2000)

    If the values with the asterisk are in column B starting in row 1, then try this:

    1- Select all of the cells you want to be formatted in the cell in column B contains an asterisk. Make sure that the active cell is in the left most column of row 1 (if the asterisks can start in row 1).

    2- Select Conditional formatting from the Format menu.

    3- In the left drop down list in the resulting dialog box select "Formula is".

    4- In the formula box next to the drop down list enter this formula:

    <pre>=NOT(ISERROR(SEARCH("~*",$B1)))
    </pre>


    5- Click on the "Format ..." button.

    6- Select whatever formatting you want when the corresponding cell in column B contains an asterisk (I would click on Patterns and select a red background to turn the cell red).

    7- Click on OK until all dialog boxes are closed.
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formatting of text (2000)

    John,

    We can drop ISNUMBER in conditional formatting.

    Aladin
    Microsoft MVP - Excel

Posting Permissions

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