+ Reply to Thread
Results 1 to 4 of 4

Formatting text and references differently

  1. #1
    Registered User
    Join Date
    03-27-2017
    Location
    Oxford England
    MS-Off Ver
    2010
    Posts
    1

    Formatting text and references differently

    I'd like to apply a conditional formatting to a range of cells, such that any cells containing a reference (=A5, say) are formatted one way and any containing a typed-in value (probably text, but possibly numerical) are formatted in another way. This is an attempt to build in a low-level audit function. Can it be done?

  2. #2
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Formatting text and references differently

    Make more than one rule.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formatting text and references differently

    Quote Originally Posted by LewisJ View Post
    Make more than one rule.
    That would say what?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formatting text and references differently

    Throck, welcome to the forum

    Im not sure that what you want is possible, because excel formulas look at the results of cells (what is displayed), not what the cell contents are

+ 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. ActiveX Combo Box -- format text of each item differently
    By puzzlelover22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2016, 03:01 PM
  2. [SOLVED] Match Differently Formatted Text Columns
    By spiphix in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2016, 07:18 PM
  3. Replies: 9
    Last Post: 07-17-2015, 04:08 PM
  4. Format cell text differently
    By aluniquen in forum Excel General
    Replies: 20
    Last Post: 01-21-2015, 11:08 AM
  5. [SOLVED] Pulling specific text within a text in which the information is typed differently
    By djmatok in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2014, 06:11 PM
  6. Replies: 11
    Last Post: 05-30-2013, 03:33 PM
  7. Formatting text differently within a Msgbox
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2005, 08: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