Excel Conditional Formatting Advanced Technique

  • Published on Mar 25, 2019
  • If you like this video, here's my entire playlist of Excel tutorials: bit.ly/tech4excel
    Learn an advanced Excel conditional formatting technique for how to format an entire row based upon the value that's in a specific cell. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents
  • Howto & StyleHowto & Style

Comments • 9

  • Tasty Crunchy
    Tasty Crunchy 2 days ago

    Hi all. I m working for medical lab reporting system build in excel. I need to do conditional formatting for a cell containing test value based on following criteria.
    1> There is a cell where user enters Gender either Male or Female.
    2> Normal range for a Male for a particular lab test is between 10 and 20.
    3> Normal range for a Female for a particular lab test is between 15 and 25.
    4> Depending on the Gender and related value, the cell value should be formatted.
    5> Example 1: if gender is Male and cell value is between 10 and 20, its normal and no formatting else format the test value cell.
    6> Example 2: if gender is Female and cell value is between 15 and 25, its normal and no formatting else format test value cell.
    I m desperately waiting for helps.

  • Cary Ballard
    Cary Ballard 2 months ago

    Liked and subscribed. Thanks for the help!

  • Bernard Joseph Concha
    Bernard Joseph Concha 3 months ago

    Thank you so much for all of your videos. They are really helpful. I just want to ask something about whenever I make a formula, Excel won't accept comma as part of it but semicolon instead. I don't know the reason behind this. I am using MS Office 2016.

  • nawar naeem
    nawar naeem 4 months ago

    i have an imei about 16 digits and i want to sequence it by sum +1 for example :1236547854123654 so when i sum it with 1 will be like this 1236547854123655 how to do it please??! I tried the normal way but it does not work

  • ElvisPresley8Jan1935
    ElvisPresley8Jan1935 4 months ago

    Love your videos.
    Question. What is the formula for this criteria?
    Using the if. Example: I want it to highlight the following. If something happens between 16 and 31 days. include the 16 and 31. I can do either but not sure how to do the in between.
    Hope you can help.thanks.

  • Voice of Overseas
    Voice of Overseas 4 months ago

    Wahoo great

  • Kathy Reese
    Kathy Reese 4 months ago

    I do not have this same "New Rule" prompts that your video shows. I am on a Mac. It does not allow me to put in a formula. Any thoughts?

    • Kathy Reese
      Kathy Reese 4 months ago

      Okay, I figured out how to find this on my Mac, but, it is also highlighting numbers less than in my formula. I used a spreadsheet with items from $6 to $26 and typed the formula as =$c1>20 It highlighted those, but also one at $6.49.

  • Leticia Ramirez
    Leticia Ramirez 4 months ago

    Great, thanks