EXCEL ME CONDITIONAL FORMATING OPTION KE BARE ME SIKHO PART - 3

Conditional Formating Ka Last Option Dekhye Aur Dhyan Se Samjhye Iske Bad Me Advance Option Bhi Bataunga Bina Samay Gawaye Shuru Karte Hai

To Dosto Ye Apka Bacha Hai Conditional Formating Me Last Option Jiska Name He “New Rule”  Isme Total 6 Option Hai Jiske Bare Me Main Apko Bataunga Chalye Shuru Karte Hai

 

“ Format All Cells Based On Their Value”      Isme Ap Condition Ke Sath  Highlight Kar Sakte Ho Ki Kis Tarah Se Apko Condition Chahiye

For Example :- Ap Set Kar Lijiye Ki Apko  Kitne Condition Ke Hisab Se Result Chahiye 2 Ya 3 Wo Aap Choose Kar Lijiye  Agar 2 Me Condition Chahiye To Ek Min Aur Dura Max Ka Option Select Kar Lijiye Aur Color Choose Kar Lijiye Aur Yadi Apko 3 Condion Ko Choose Karna He To Ek Min  Dusra Mid Aur Tisra Max Select Kar Lijiye Aur Color Choose Kar Lijiye Fir Apko Isi Ke According Result Milega

Example :-

 

Fir Asa Hi Result Ayega Is Tarah Se

     “Format Only Cells That Contains"     Isme Ap Koi Specific Text Ya Blank Name Ke Hisab Se Kuch Bhi Highlight Karwa Sakte Ho Jaisa Ki Option Me Dikhaya Gaya Hai

  “Format Only Top Or Button Ranked Value “      Ap Kitne Above Ya Below Value Highlight Karwana Chahte Ho Number  Deke Karwa Sakte Ho

"Format Only Values That Are Above Or Below  Average" :- Isme 6  Below Ya 6 Above Highlight Karwa Sakte Ho

Format Only Unique Or Dublicate Value :-  Isme Aap Dublicate Ya Different Value Highlight Karwa Sakte Ho

 

 "Use A Formula To Determine Which Cell To Format" :- Aur Isme Ap Formulas Lagake Highlight Kar Sakte Ho

Compelete Hua Apka Conditional Formating Option

 

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH