+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Not Working

Hybrid View

Peaceful Jim Conditional Formatting Not... 05-20-2017, 08:51 PM
Logit Re: Conditional Formatting... 05-21-2017, 12:25 AM
Peaceful Jim Re: Conditional Formatting... 05-21-2017, 01:54 AM
Logit Re: Conditional Formatting... 05-21-2017, 11:33 AM
  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,397

    Re: Conditional Formatting Not Working

    .
    .
    Try pasting this into the Sheet level module :

    Option Explicit
    
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim MR, Cell As Range
    
    Set MR = Range("G6:BF24")
        For Each Cell In MR
            If Cell.Value = "/" Then
                Cell.Interior.ColorIndex = 15
            Else
                Cell.Interior.ColorIndex = 0
            End If
        Next
    End Sub
    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,397

    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