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

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.

## 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??????

(June 13, 2018 - 12:35 pm)

#### pietraco09

(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