How To: MS Excel| Advanced Conditional Formatting (Formula Base)

Learn in Urdu/Hindi Advanced Conditional Formatting on Formula Based.
There are 10 scenarios elaborate including

Color Every 2nd Row.
Compare 2 Lists
make Check List
Heat Map
KPI Map
Highlight a Row based on a Cell Value/Text
Hide Data a specific Row
Highlight Duplicates except 1st occurrence
Make Search Box
Make Multiple Search Box
Gantt Chart

In this tutorial we have used following Functions & Tools:
MOD
ROW
COUNTIF
AND
OR
Name Manager