Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove specific conditional formatting

    Hello everyone
    I followed this great forum and I liked the way you offer solutions. Really fascinating

    I have a worksheet in which I put some conditional formatting formulas ...

    I know a way to remove all the conditional formatting formulas but I wonder if there is a way to delete or remove specific conditional formatting?
    My Conditional formatting which I want to remove

    Code:
    =IF($O$1="Yes",TRUE,FALSE)
    This formula is used as a switch to enable / disable conditional formatting ...
    Thanks advanced

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Firstly, you could simplify that conditional format formula to just
    =$O$1="Yes"
    ..instead of
    =IF($O$1="Yes",TRUE,FALSE)

    Now, regarding your question, do you want a vba solution or a 'manual' solution???
    For a 'manual' solution, you could press the 'GoTo' key [F5] >Special>Conditional Formats>[OK]
    ..then use the top-panel Ribbon command Home>Conditional Formatting>Manage Rules
    ..then select each occurrence of the relevant rule and [Delete Rule]

    zeddy

  3. #3
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks a lot for help
    I need VBA solution ..
    Another important point for manual solution :::
    There are three cf formulas : one for range("A2:A100") , one for range("B2:B100") , and the last for range("C2:C500")
    So I thought of range("A2:C100") to gather the three ranges an disable them (using the switch cell O1)
    If I followed your manual steps I would remove the four cf formulas while I need to remove only one of the four

    If there is a way without depending on the cell O1 It would be better for me?
    I prefer using vba ...

    As an idea : what about storing the existing cf formulas by vba ..then removing all .. and by using the stored cf formulas I could back them again (I don't know if it is possible or not)

  4. #4
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Another idea:
    Is there a way in VBA to identify the formula
    Code:
    =$O$1="Yes"
    then remove this specific formula in CF?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •