+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Not Working

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    QLD, Australia
    MS-Off Ver
    365
    Posts
    14

    Conditional Formatting Not Working

    Hey guys,

    Here to be saved once again (hopefully) by this helpful community.

    Long story short, we have conditional formatting on a sheet. I cut and pasted one row and placed it elsewhere on the sheet. I deleted some cells on the row that I pasted, and it affected ALL of the other cells that contained the same thing. In this case, every cell that contains the / symbol has been affected. Please see the screen shot for details.

    https://i.gyazo.com/e6ad75e14502a31c...eaf47661c7.png

    I've got conditional formatting that should make every cell that contains / to turn a dark grey, yet this is not activating.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,395

    Re: Conditional Formatting Not Working

    .
    .
    Try pasting this into the Sheet level module :

    Please Login or Register  to view this content.
    That will do away with the conditional formatting but still give you the result you are seeking no matter what changes
    are made to the range G6:BF24

  3. #3
    Registered User
    Join Date
    03-15-2017
    Location
    QLD, Australia
    MS-Off Ver
    365
    Posts
    14

    Re: Conditional Formatting Not Working

    Thank you for the reply.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,395

    Re: Conditional Formatting Not Working

    You are welcome

+ 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. [SOLVED] Conditional Formatting not working
    By timmtamm in forum Excel General
    Replies: 5
    Last Post: 03-15-2017, 09:45 PM
  2. Conditional Formatting - Not working
    By pskwaak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-03-2014, 11:13 AM
  3. Conditional Formatting not working.
    By EquityTrader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 12:50 PM
  4. Several Conditional Formatting only working on some
    By joblinger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2009, 05:17 PM
  5. VBA conditional formatting not working
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2008, 09:43 AM
  6. Conditional Formatting is not working...
    By tmerton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2006, 06:55 PM
  7. [SOLVED] Conditional Formatting not working
    By Crowbar via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2005, 03:15 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