Turn Conditional Formatting On or Off

Поделиться
HTML-код
  • Опубликовано: 2 ноя 2024

Комментарии • 19

  • @holyone2668
    @holyone2668 5 месяцев назад

    Thank you for this. I’m not very good with excel and this is going to make me look good at work.

  • @wayneedmondson1065
    @wayneedmondson1065 2 года назад

    Hi Gasper. Very clever and useful trick! Stop If True.. much easier than adding conditions to each rule separately. Brilliant! Thanks for demonstrating. Thumbs up!!

    • @ExcelOlympics
      @ExcelOlympics  2 года назад +1

      Glad to hear that you liked it Wayne. See you on the next one 😀

    • @wayneedmondson1065
      @wayneedmondson1065 2 года назад

      @@ExcelOlympics Looking forward to it!!

  • @OzduSoleilDATA
    @OzduSoleilDATA 2 года назад

    WOW! This is impressive, and a great use case. I like this. 🔥🔥🔥

  • @IlgarZarbaliyev
    @IlgarZarbaliyev 2 года назад

    Wonderful! I appreciate your way of explanation. Thank you for this video.

    • @ExcelOlympics
      @ExcelOlympics  2 года назад +1

      Thank you for those kind words. It means a lot!

  • @TheLaopi
    @TheLaopi Год назад

    Very great, 👏👏👏👏

  • @panplusk9539
    @panplusk9539 Год назад

    So if i toggle formatting off, will it actually improve performance for large datasets? Or does it count as a rule, and performance stays the same. If it improved things it`d be a game changing trick for me. Im asking because i cant get my hands on a real dataset in next 2 weeks (covid), and im too lazy to create believable 100k+ rows, 50 columns set with formulas out of my ass.
    Anyhow, watched a few videos of Yours today, quality content, already subscribed. Thanks!

  • @hichamhadj9640
    @hichamhadj9640 8 месяцев назад

    Awesome

  • @martyc5674
    @martyc5674 2 года назад +1

    Nice trick… I thought you were going to add “AND C4 = False” into each rule 👍

    • @ExcelOlympics
      @ExcelOlympics  2 года назад +1

      Thanks, Martin.
      Sometimes there is an easier way in Excel. I think we are programmed to search for the "technical" solution and not to think "there has to be an easier way" 😀

    • @rubenmunozverdu7528
      @rubenmunozverdu7528 2 года назад

      Same as Martin. I would have added AND NOT C4 in the existing rules

    • @ExcelOlympics
      @ExcelOlympics  2 года назад +1

      And it would have worked just fine, Ruben. But now you will save yourself two minutes for a relaxing off-time :)

  • @jerrydellasala7643
    @jerrydellasala7643 2 года назад

    Love the trick, hate the download file! Still, 👍

    • @ExcelOlympics
      @ExcelOlympics  2 года назад

      Thanks for that catch, Jerry. It's the all bellowed AutoSave playing tricks on me (again). I have removed it from the description. Thanks again!

    • @ExcelOlympics
      @ExcelOlympics  2 года назад

      Just reloaded the file. Here is the link to the correct one:
      excelolympics.com/wp-content/uploads/2022/03/Conditional-Formatting-OnOff1.xlsx
      Thanks again!