+ Reply to Thread
Results 1 to 2 of 2

conditional formatting disappearing text

  1. #1
    Registered User
    Join Date
    09-10-2017
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    63

    conditional formatting disappearing text

    Hi All

    Does anybody know a formula or formatting trick so that when I type text in one column it is erased from another column? Obviously this would only apply if I am typing a duplicate value. See example below and attached. For example, if I were to type Tampa Bay Buccaneers in column E2, it would be removed from column B15. Hope this makes sense.

    Thanks for any ideas/help!

    Capture1.PNG

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: conditional formatting disappearing text

    in column B, if the data is based on formulas, then you can precede it with an IF statement, but if it is text then you could use VBA to clear the cell, or use conditional formatting that if the cell in column B is same as in column E then make the text white, and fill with white.
    Last edited by janmorris; 09-06-2021 at 01:55 PM.

+ 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. Replies: 11
    Last Post: 02-25-2019, 06:29 AM
  2. Replies: 6
    Last Post: 11-19-2018, 09:46 AM
  3. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  4. [SOLVED] Conditional formatting to mark cells with on text strnig but lacking another text string
    By KArnoldColumbia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 04:15 PM
  5. Replies: 3
    Last Post: 11-04-2013, 12:47 AM
  6. [SOLVED] Conditional Formatting (Adding text and cell formatting)
    By fredjones in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-26-2012, 04:15 AM
  7. Border Formatting Disappearing when data entered into cell
    By Orgelfreude in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 09: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