+ Reply to Thread
Results 1 to 2 of 2

How to conditionally format a cell, then remove formatting when cell is no longer blank

  1. #1
    Registered User
    Join Date
    05-14-2019
    Location
    Louisville, KY
    MS-Off Ver
    1904
    Posts
    7

    How to conditionally format a cell, then remove formatting when cell is no longer blank

    I?m having trouble creating some conditional formatting rules in excel.
    Each rule below I believe could be done with the same/similar conditional formatting formula, I just can't figure it out.
    Any help would be appreciated.

    RULE #1
    If ?Deal Source? is ?Frazer Portal? or ?Frazer Sale? then highlight ?Frazer Rep? cell in yellow. Once the yellow cell is no longer blank, remove the yellow formatting.


    RULE #2
    If ?Deal Source? matches any of the following, then highlight the ?Lead Tracking SS Updated? cell in yellow. Once the yellow cell is no longer blank, remove the yellow formatting.
    Web Lead
    Callin Lead - New
    Callin Lead - Upsell
    Frazer Portal
    Frazer CS

    RULE #3
    If ?Deal Source? matches any of the following, then highlight the ?Frazer Tracking SS Updated? cell in yellow. Once the yellow cell is no longer blank, remove the yellow formatting.
    Frazer Portal
    Frazer Sale
    Frazer CS
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: How to conditionally format a cell, then remove formatting when cell is no longer blan

    Hi
    For each rule I have made a list in next sheet with options listed by you and i used it in a match formula In CF
    For rule 1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    for rule 2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    for rule 3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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: 15
    Last Post: 07-31-2020, 10:10 AM
  2. Replies: 1
    Last Post: 01-04-2017, 06:00 PM
  3. Replies: 1
    Last Post: 01-04-2017, 05:59 PM
  4. Replies: 1
    Last Post: 07-03-2014, 06:33 AM
  5. [SOLVED] conditionally format the first value to the right of a blank cell
    By skoehler9 in forum Excel General
    Replies: 10
    Last Post: 09-14-2012, 04:21 PM
  6. Conditionally formatting a blank cell to red .
    By Excelinfant_2010 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-10-2010, 02:45 PM
  7. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM

Tags for this Thread

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