Скачать или смотреть How To Hide Rows Based On Cell Color In Excel

How to hide rows based on cell color in excel?
In this advanced excel tutorial, I'll explain how you can hide multiple rows at once based on the cell color. Suppose you have a data sheet where all the completed projects are marked yellow. Now you need to hide all the rows that have yellow cell color. It's really hard to manually find excel cells and then hide them one by one. In this tutorial, we'll use Visual Basic for Application to do this task. But you don't need to learn VBA for this. I've already prepared the code for you. Just copy the code and follow the video instruction, and you'll easily hide rows based on cell color. But you need to learn the color index number for this. Here is how you can find the color index number in excel:    • How To Get Color Index Number In Excel  
Now follow the instructions below to Hide multiple rows based on cell color in excel.
1. Click on the developer and click on visual basic. If you can't find the "Developer" tab in the ribbon; here is how to find it:    • How to add developer tab in excel  
2. Now click insert and then module.
3. Now, write the code and specify the color index number. (Please subscribe, and here goes the code:   / 68282730  )
4. Click "Run" and select the range from where you want to hide the rows.
5. Click ok and done.

#HideRow #exceltutorial
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial