+ Reply to Thread
Results 1 to 5 of 5

Highlight Text (non formula) Cell

  1. 04-22-2014, 02:41 PM #1
    Ocean Zhang
    Ocean Zhang is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    Highlight Text (non formula) Cell

    I want to highlight cells that don't contain a formula. Is this possible?

    Thanks
    Last edited by Ocean Zhang; 04-22-2014 at 03:00 PM.
    Reply With QuoteRegister To Reply
  2. 04-22-2014, 02:49 PM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,003

    Re: Highlight Text (non formula) Cell

    Yes, with VBA
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
  3. 04-22-2014, 02:53 PM #3
    Ocean Zhang
    Ocean Zhang is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    Re: Highlight Text (non formula) Cell

    ugh. no way to do it with conditional formatting?
    Reply With QuoteRegister To Reply
  4. 04-22-2014, 02:57 PM #4
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,003

    Re: Highlight Text (non formula) Cell

    No. CF look contents of the cell. Not how it get it.
    Reply With QuoteRegister To Reply
  5. 04-22-2014, 02:59 PM #5
    Ocean Zhang
    Ocean Zhang is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    Re: Highlight Text (non formula) Cell

    ok thanks for the tip
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to highlight text within formula
    By iqbal@khan in forum Excel General
    Replies: 1
    Last Post: 03-11-2014, 02:31 PM
  2. Highlight part of text in cell - not "fill" cell or change color of text
    By kwindham in forum Excel General
    Replies: 8
    Last Post: 01-28-2014, 05:15 PM
  3. highlight the cell that contains different text
    By loade in forum Excel General
    Replies: 1
    Last Post: 07-05-2012, 02:59 PM
  4. If text in cell equals text in another cell, highlight both same color.
    By xi Slick ix in forum Excel General
    Replies: 8
    Last Post: 03-30-2012, 07:52 PM
  5. Formula to highlight an entire row when certain text is present.
    By bcholin in forum Excel General
    Replies: 3
    Last Post: 09-06-2005, 03: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1