Everything About Conditional formatting in MS Excel | Efficiency 365

[@vijayarjunwadkar]

Superb as usual! Thank you Dr. Nitin! What I like most about your videos, is the reasoning behind everything that you explain so well, and demonstrate practically which really helps!

[@efficiency365]

Thanks Vijay.
More stuff coming soon.
Too much AI floating around - again the same story - we have to deflate the hype and find practical benefit!

[@jkumar8590]

Very nice Dr. Please combine all your bits and pieces into a course so that people can learn continuously.

[@efficiency365]

Thanks for your encouragement. I know this is delayed from my side.
Want to do it. Coming soon.

[@eeettt8701]

Very helpful

[@efficiency365]

Thanks @eeettt8701
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@jaswinderbhatti3352]

I learned it recently while trying to create the Gantt chart for my project .. even MS gives template and example in you tube how to create the Gantt chart … Conditional formatting is the base and important aspect in GANTT charts …

[@efficiency365]

Thanks @jaswinderbhatti3352
Oh... Don't use Excel for Gantt Charts. Use Draw.IO. It is free.
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.

[@ademb]

Hi Dr I love all your videos. It was only yesterday where I found out if your excel spreadsheet contains tables with filters applied, if you try and do a ctrl f and search for a word but that word is filtered out, excel will not be able to find that word and say it doesn’t exist. Is there a way to perform a search which would bring back those results in that circumstance? Imagine the spreadsheet is very large with many sheets so going into every sheet manually and unfiltering is not an option?

[@efficiency365]

Thanks @ademb
NO solution for this. It is by design.
With programming it is possible to build a REAL FIND feature.
I have not searched for them, but there must be tools / utilities that do this already.
The more interesting part is - since 40 years, billions of users seem to be ok with this apparent shortcoming 😎
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc