Excel - 4 Smart 👌Advanced Custom Conditional Formatting Tips [ New Rules ] To Make You 😎Smart

Advanced Excel - 4 Smart Amazing Advanced Custom Conditional Formatting Tips [ New Rules ] To Make You Smart. Custom Conditional formatting is really easy to use once you understand the rule behind it. This video shows you how how you can use your custom formulas in conditional formatting rules in Excel and conditionally format them to change color depending whether a condition is met or not. In this lecture you will learn how you can use conditional formatting smartly to highlight -

1. Highlight column values
2. Highlight Entire Row
3. Highlight Entire Column
4. Highlight Entire Row

Learn how to use conditional formatting to change the look of cells in your sheet when they meet certain conditions.

Download Training File

Advanced Excel 5 Super Hidden Secrets & Data Hiding Tips & Tricks To Make You SmArT

Vlookup In Excel - VLOOKUP VIDEO SERIES:

1. vlookup in excel with example in Hindi

2. How to use vlookup for multiple values || Trick to use vlookup for large data

3. Vlookup in multiple sheets in excel || In Hindi

4. How To Use Double VLookup in Excel-Nested vlookup

5. Dynamically Updated Vlookup Formula in Excel

6. How To Use Vlookup With Multiple Excel Workbooks

7. VLOOKUP With MATCH Function In Excel

8. HLOOKUP in excel with example in Hindi

9. Hlookup With Match Function in Excel in Hindi

My Channels :

#conditionalformatting
#excel
#deepakeduworld

Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.

Deepak EduWorld Playlist's:

POWERPOINT COURSE ►

ADVANCED EXCEL ►

ADVANCED EXCEL FORMULAS ►

EXCEL TIPS & TRICKS ►

MS WORD ►

HTML5 & CSS3 ►

COMPUTER TECHNICAL videos ►

AUTOMATIC INVOICE IN EXCEL ►

PHOTOSHOP ►

excel conditional formatting,excel custom formatting,excel conditional formatting color,formatting,formatting rules,char in conditional formatting,conditional formatting,conditional formatting in excel,conditional formatting in excel in hindi,ms excel advanced conditional formatting,conditional formatting excel,deepak eduworld

[KaileshHambireIJ-G-]

Thank you Deepak JI, I was looking to learn conditional formatting since many years, but was not able to learn in my classes, I really feel satisfied by watching your all videos on conditional formatting. Thank you once again, & God Bless.

[umeshtambe]

Hi Deepak,
Thank you for sharing your expertise. Thanks, this is exactly what I was looking for. Wonderful, this is more than I expected.👍👍👍

[khalidalisubhanallah]

Bundle of Thanks Sir Dil Khush Kardia Maza Agaya.

[bittukundan]

Deepak Sir, mujhe aap k videos se bohot kuch sikhane ko milta h thanks U So much

[kalamazad.]

You're no 1 teacher in youtube....specially i got in ur videos u keep talking in Hindi...its help us to make fast understanding...
Thanks Deepak Bhai.

[sachinjakhmola]

thanks sir . youtube me bahut se channels hain par jaisa aap samjhate to wo baat maine ab tak kisi me nahi dekhi.

[MrJagdish]

Thank you sir
God bless you and give more energy to create useful vedio
Regards and best wishes

[devendrasharma]

Thanky you sir apke chanell se kafi kuch sikha ho

[bhole]

Excellent sir
I was searching this tyoe of video.
Thanks a lot

[jitendrabomble]

Thanks sir.
Very useful lesson.
👌👌👍👍🌹🌹

[rajpalthakur]

Deepak sir aapke video me Jo clearity hoti hai and Jo sound hota hai WO baki other video me nahi aur aap formulas lagate time zoom karke batate ho WO sabse best hai

[specials.konoffice]

bahut acchaa sir bahut achhaa maja aa gawa

[rafatali]

Sir Superb vdo
God bless you with your fmly 😊

[shaileendrapandey]

I was searching this from from long days actually thiese type of vedeo supported to all who is doing job in private company specially because its more required for this.
SPECIALLY THANKS TO DEEPAK SIR AND APPRECIATE ALL YOUR BRILLIANT JOB ITS VERY HELPUL FOR ALL WHO IS BIGGNRR, EXPERIENCED. ❤️❤️❤️ ALSO AWAITING POST NEW VEDEOS FOR MORE GUYS DO PLEASE UPLOAD NEW SHARP TIP VEDEOS 👍👍👍

[konsamprincesingh]

I learned so many things about excel from your videos. Thanks to you, I am able to develop a data entry system after watching many of your vidoes. The current video of conditional formatting is enlightening and taught very easily. But in a data with more than thousands of rows, finding the coloured row is difficult and one has to scroll down till the same is found. I am able to find data using VLOOKUP but want to have the option of editing without using VBA. Please do a video on data entry with the option of editing existing data without going to the cell itself. Regards.

[puneetvij]

Deepak Sir,
गज़ब की trick है | Excellent ! ; )

[rotty]

thanks sir for your valuable information

[mohdshehzaadkhan]

Thanks for upload very most useful vedio. I really appreciate you please keep posted like this video we are eagerly waiting for new.