Conditional Formatting In Excel: Less Than, Greater Than, Equal To

About this tutorial:

Video duration: 4:11
A lecture from my “Easy Excel Conditional Formatting” course on Udemy. Here you learn how to use the numbers-based conditional formatting rules.

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “Conditional Formatting In Excel: Less Than, Greater Than, Equal To

    Clementino T Malengue

    (June 13, 2018 - 12:35 pm)

    Thanks for your video. It helped me a lot. I have problem now comparing and highlighting the two excel different tables on the same sheet; for ex. with 6 raws and 6 columns compared to another table with the same raws and tables = colour if less than… Please help. Thanks on advance

    eWaqas Amin

    (June 13, 2018 - 12:35 pm)

    Hello Sir,

    I am really in need of a formalu, PlZ help

    I have same numbers in a cell with operation symbols, I need their result in next cell as a formula directly.
    For example I have values in a particular cell as 56+38+92-20+10-30.
    Now I need its answer to be exactly 146 with the help of formula in the next cell.
    i have a long list, is it possible??????

    Mohammad Ahsan

    (June 13, 2018 - 12:35 pm)

    Thankz sir…it is helpful


    (June 13, 2018 - 12:35 pm)

    hi Higor, I have a problem, I want to have 5 different prices which are based on volume: from 1 to 25 the price is = 100, from 26 to 50 the price is= 80, from 51 to 75 the price is= 70, from 76 to 100 the price is = 60 and from >100 the price is = 50. I have tried to use the nested if formula but all i get is the first two prices to be calculated ?

    Cameron Rivera

    (June 13, 2018 - 12:35 pm)

    How would i find the count for the highlighted cells?

    Tomica & Trackmaster

    (June 13, 2018 - 12:35 pm)

    you are the best thank you so much

Leave a Reply

Your email address will not be published. Required fields are marked *