Excel Highlight rows and records 

5 years later and I am so greatful for your video. Clear and easy explanations by far. Thank you.

I literally spent half my work day trying to do this the other way that doesn't include the drop box - but THIS! With the drob box!? Amazing!! And it was soooo easy when i followed your clear directions - thank you!!! Now my spreadsheet is impressive!

everytime I want to share this with anyone, i already anticipate the way they will look at me as I am an excel nerd. No, I keep the magic of excel to myself

thanks, it's 2023 and it works awesome... Life saver.

Working on a Sudoku game in Excel and needed to learn how to highlight certain numbers that had already been played and this worked great. Thanks

It was exactly what I was looking for.. a lifesaver thanks so much for a complete tutorial!

I have an exam today and I'm sure he's gonna give us this, I'm thankful for your video i feel like i finally understand how to do it 🙏❤️

I learned so much! Beautiful and clear explanation. Thank you! I need other tutoring to build a budgeting in excel.

We learn this in macros in Excel, but this is much easier, thank you for sharing. I tried the step by step on my mac and it was successful.

PERFECT, Exactly what I needed with less key strokes... The other way I was doing this was writing it into "1" cell then copying and pasting, etc.. etc... BLAH!!!! Your way was a time saver, thank you!!!!!

Wow!! Thank you for this amazing tutorial! My struggle was the formula in formatting... thank you!! 🏁👍🤗🎉

Thank you for your tutorial!!. You explain extremely well from dropdown list to conditional formatting to an Entire Row. 👍👍👍😁😁😁😁

Good Evening I was trying to do samething but fail now i saw this in youtube display so i watch this video n now my concept is clear Thanks dear respected sir Nice video Keep it up May God bless you with his rehmat Ameen 🏅for you

awesome your video really helped me out, and you really explain it patiently for those of us who just want an answer and nothing more!! thank you

It was very helpful I love working with excel and this just made it easier and faster.

Thank you so much. Easy to follow and it works great. You saved me tons of time

A nice demonstration of conditional formatting. Thank you.

Thank you so muc.it's really helping me alot doing my jobs and easy to find my drob list data.

It's super practical.. But who are those 59 who waste their time to put a dislike

*Once you do this, how can you tell Excel to GRAB THE DATA and move it to another sheet? Or maybe is there a copy function that will pick ONLY the highlighted cells?*

Why not just filter the columns?

your tutorial is so much effective. I really enjoy it!

Good Explanation - Thanks

You are the man!!!!!!!! Thank you!

Simple and informative way look to for desired data in a large table.

God bless you 🤗 ill be sure to share the knowledge.

exactly what I was looking for! Thanks

To select a specific data for multiple columns I would just need to set up the specific data set multiple times depending on my column headers right

Thank You very much for the useful sharing, excellent !

Great tutorial. Wouldnt filter do the same? ,

Very nice. You have highlighted the rows with colour. In the same way, whether we can highlight the colours of particular column?

Very cool! Thanks

awesome...thats what i was looking for

I'm loving this 👏👏👏👏👏

Thanks for sharing, its very helpful

VERY GREAT TUTORIAL..!!!!!! PLEASE DO MORE TUTORIAL LIKE THIS.TQ.

Many thanks for sharing. Excellent stuff.

Great Video ,Very Helpful

so much informative I have learned using conditional formatting

Easy but very useful, thank you very much!

Thank you it was helpful for me

Wow been looking for this for a while, Thanks! Is there a way to find the unique values of the "department" list without having to make another copy of the list on a separate sheet?

Good explanation.

Thanks alot...Sir...you make my day

Basic question: how did excel know to highlight the entire row that contained the matching department as opposed to just the matching cell?

thank you it was very helpful

Thank you so much sir this process will surely save my time....

Nice it's helpful for me I use your technique with my own condition some different.

Thank you this is very helpful. If you had a cheat sheet I would use it!

Super useful, thanks a ton

super useful ... Thanks

can you help me (great video by the way made my life a lot easier. I use excel to log jobs, dates, costs, and expenses in rows. When a job has been invoiced I mark the whole row with a green background. The problem i am having is that if I mark the last row off green, when I start to fill in details on the row below they automatically show with a green background, can you tell me why and how I can stop this from happening?

WHY DID I NOT FIND THIS VIDEO YEARS AGO!!!!!!!!!!!

Wow! It’s really useful knowledge! Thanks for sharing 👌👍

Easy & very usefull

Million thanks for your tutorial! Keep it up

Thanks a lot, this is super useful!

Thank you for share.

Sir, please tell me. How is that applicable on multiple drop-downs column, linked to this whole data table or just a specific column only, from another sheet???

It's really good. But kindly tell me is there any way to copy all the highlighted rows at once???

If you a single column data transfer to another worksheet then if you delete those data that will not work the previous sheet

tricky perfect, worked like designing

Very very Very. THANKS..........!

Very useful video sir. What about auto populate the serial number so that no need to count the number of items manually

SUPER AWESOME

Very Helpful!

Thanks a lot for this tutorial.

Better yet to use sort and unique so it will be a dynamic data validation and no need to update the validation list when there is a new department.

*Thank you for the tutorial Excel brother and sister*

Really very Nice!!

very use full thank for video and best explanation ...

How if E column input number color is red then A column input number and B column input text color also will be red ?

This was a great tutorial! The only problem I have is when I add data it doesn't highlight.

I already applied this formula .now I want to finish it. How? Plz guide me

thanks you for giving a wonderful information but with me when i do that the above line been highlighted rather then the required line when i click any required department can any one help

Well explained. Thank you.

I have a large spreadsheet and would like to color each row based upon the value in column A on a second tab. For example: employees are grouped into teams with a representing color. On an accounts list that has the assigned employee in column a - I need for that row of data’s cells to match the team color. There are 3 teams so I would need it to loop back until it’s gone through all colors. Can someone please assist?

nice tip thanks for your efford

Thank you so much for this. It has helped me a great deal

Great function. Can you add other columns that match? If I am looking in Dept for toys or electronics that match the region, item # and quantity in this examples. So Toys from SE matching item# 8001 with a quantity of 14 that all match. Since I won't know if any or which ones match can excel search all Depts and compare 3 or more columns? Thanks

HELLO, DO YOU KNOW HOW TO USE CONDITIONAL FORMATING TO HIGHLIGH ROWS AND COLUMNS WHEN MULTIPLE CELLS ARE SELECTED. SUCH AS WHEN SELECTED FROM A3 TO D5 WITHIN A RANGE THE COLUMN FROM A TO D AND ROW FROM 3 TO 5 ARE HIGHLIGHTED. THIS NEEDS TO BE DYNAMIC TOO. THANKS IN ADVANCE.

Excellent !

Wow!! Thank you so much! This is really helpful!

Thanks too much Sir

Very clear, thank you!

Okay that was good but how about if I only wanted col(A:B &D:E) to be highlighted?

Bundle of Thank Sir

Thanks bro but f4 key was not working in my laptop if you know this suggest me

Great! What if you want to keep the duplicates on your master data set, but want to Highlight them when your department, item number, and total are the same between rows. So if when you upload the data, row 1 and 2 have the same department, item number, and total, those rows would highlight

what formula do we put with the cell if we dont want it to hightlight empty cells in the table?

Very much appreciated!

Pls explain in details why you used absolute referenced Column

Can you select multiple columns with the absolute feature in the same rule in the event I have staggered columns?@6:22 in video

thanks for below. Can you please give me an example where can it be used..?

I pressed F4 twice but it aint unlocking the formula for me.. instead it shift to a next column

Thanks a lot for the tutorial.

Incredible

Looks good

It was very much useful to me txs

Hello I am trying to use your tip from this video to help clean up a data file. I am struggling with creating the conditional format. When I select the item in the drop down list, excel is not highlighting the item selected. If you could help that would be greatly appreciative. Have a great day!